• 01 Oct 2021
  • Working period : 1 months, 23 days
Screenshots

Media Library

We have created custom code to import Product data in WordPress Woocommerce Database. As per requirement, we have to import 2 Feed APIs. We also need to modify the price, category mapping, product image mapping, and other woocommerce product attributes.  Keep up to date product inventory, stocks, images, category wise products with load sharing algorithm by TheFoxLab which will run even in shared hosting. We highly recommended using dedicated hosting for your e-commerce website if more than 30k products. 

Here are steps we follow to fulfilled needs:
  1. Parse Product XML feed and populate products into the database. The cron script will import products, images, featured images, product attributes.
  2. Parse Product Stock XML API which runs frequently to update Stock on daily basis.
  3. CRON set up in a round-robin fashion, We created a text file with pagination so when cron run then read from the last offset because XML feed is too big (around 1.5 GB with 30k products).
  4. The program will update 30k records in 4 days :) cron frequency set every 4 minutes and process 20 products :)

Git used for processing large XML files:  

https://github.com/prewk/xml-string-streamer
 
Technology used
  • img Ecommerce
  • img PHP
  • img Woocommerce
  • img Wordpress
  • Service offered
  • img WordPress Development