Jump to content

Product Import Module/Script CSV Cronjob for PrestaShop


aliasali

Recommended Posts

We’ve got an online webshop. We have a physical stock, but we want to develop a module that imports automatically products of our supplier(s) directly into the webshop (without changing our physical stock).

 

We would like to create a module in which it is possible to import or disable products with a cronjob. The cronjob needs to be able to consult at least five suppliers at different times. For example, CSV file from supplier 1 can be consult at 00.00 o’clock, CSV file from supplier 2 at 01.00 o’clock etc.

Also, I would like to import new products from my suppliers, only containing an EAN code/Supplier Reference.

 

The module needs to contain the following aspects:

- Every day, for example, at 00:00 o’clock, the module needs to connect the database of our webshop, with the CSV-file from the supplier, at that time.

 

- It needs to look first at EAN 13 row/Supplier Reference, and then at the stock. Because some EAN numbers/Supplier Reference we have on (physical) stock (stock = > 1), and this products may therefore be ignored.

 

- First of all the module needs to look at ‘ EAN 13 ’ and ‘Supplier Reference’ , and look for matches between and EAN code/Supplier Reference (product) from our webshop and search for the same EAN code/ Supplier Reference (product) with the CSV files of the suppliers. If there are matches found, the next step is to look at the stock of the product with a specific EAN code/Supplier Reference. If the stock in the webshop is 1 or more, this product (with the EAN code/Supplier Reference) must be ignored. If the stock in the webshop is 0 or less, then it is important that the module will check the stock at the supplier(list). When there is no match between an EAN13/Supplier Reference from our webshop and an CSV file from the supplierlist, then this product must be disabled. Because this product is not available at the supplierlist. If there are EAN 13/Supplier Reference found in the supplier list, but who are not existing in our webshop, these product must be added into our webshop. But these products must be disabled, so that we can choose if we want to show/sell this product or not. New products need to be placed in the category ‘New products’ , what we already created. If this is the case, the module needs to make a new product and take over all the fields of the supplier (product name, ean-code, supplier reference, description etc.). The stock of new products needs to be automatically set to zero, because we don’t have any physical stock yet.

 

- Why has the stock needs to be set to zero? If the next day the stock of this item is already zero at the supplier, we can disable this product.

 

- Another advantage of this module will be that products what we had in the past, but who were sold at the supplier, may be reintroduced when there is new stock at the supplier.

 

- “The person who will develop this module need to have some knowledge of Prestashop, Developing modules ho can work with cronjobs, Importing Modules/Scripts/Cronjobs” . It is also important that this person will ensure that this developed module will work at our webshop, thereby ‘based on’ Prestashop.

Link to comment
Share on other sites

Hello,

We have already done something similar for another client. We have developed module to sync Prestashop products with client's ERP system for managing physical shops.

Each 15 minutes cron job starts a job to imported CSV from ERP and synchronize products in shop with ERP data (stock and price).

New products are added to catalog and existing are updated. All products come in different combinations of colors and sizes.

 

If you are interested we can discuss further on this.

  • Like 1
Link to comment
Share on other sites

  • 10 months later...
  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...