Use import function to update products?

[mytheory.]

Hello,

I was wondering if the default import function included with PS could be used to update products.

We are using a in-house program for inventory/warehouse management, but have transitioned to PS for our webshop. The (big) problem is that the in-house program was programmed to use MSSQL and obviously PS uses MySQL. We have a lot of products that need to be updated weekly (sometimes daily) from the in-house program to our webstore.

All new products and final (official) orders are updated through this in-house management program... so after all transactions they still need to be updated in PS, since there is no way to accomplish this as of right now. If there is a program/module/method that would make connecting these two db's possible, please do let me know even if it will cost to have a connector programed.

So the alternative we are looking at is to export the data from the MSSQL to an excel file. Then to create a csv... and then use that with the import function to update product information, more specifically the quantity. Would this be possible?

Like our system uses unique "reference" numbers (item numbers in our case), so would it be possible to have 1 column with these reference numbers (of products already in PS) and then to import the new quantity for those products? Or does the import function not work like this?

THANKS!!

[rocky]

Unfortunately, it does not work that way. PrestaShop's import function uses to product ID to update products, not the product reference. You'll need to create a product CSV file with the product IDs and quantities and then import it to update the quantities.

[mytheory.]

So if I got all the product ID's of the products in our shop and matched does up with respective quantities and imported this file without deleting all the products... PS would update all quantities for those Product ID's??

So for example, we have 1 column for the "Product IDs" and 1 column for the "Quantity", without deleting or modifying anything else PS would find those Product IDs and replace the existing quantity with that of the new Quantity as defined in the second column?

Many thanks!

[rocky]

Yes, it should work. Make a backup of your database and try it. If something goes wrong, you can restore your backup.

[netman]

I am having the exactly same problem. My customer has an in-house inventory management system. They have a few different PS websites selling different products from the same central database. They need to update product quantities of the websites on a daily basis. All databases share the same product codes but contain different sets of products. My problem is to find an easy way of updating all the websites without too much manual work.

I can get a csv export file from the central database. The question is how to extract the quantiy information of a certain number of products from the csv file and import it into PS website. Anybody knows an easy way of achieve this?


Thanks

PS: The central database contains about 1000 items. Each website has about 400-600 products from the main inventory.

[guest*]

Perhaps this post will help: http://www.prestashop.com/forums/viewthread/19764/P30/general_discussion/solvedautomatic_update_product_quantities/

[vfenix]

i think this module can help you, but it's in spanish.

you need to upload your csv file to the module folder, and you've to call it update.csv.

later you choose the id, the reference, etc... how guide to update your products, and his position inside the csv.

later you choose what field to update, price or stock, and his position inside the csv.

if you have dubts, just you need to use the google translator.

and... if someone wants to improve the plugin... it's welcome ^^, but please, to share your changes with the community.

Thank you.

more info and downloads:

http://todoprestashop.com/foro/viewtopic.php?f=16&t=5274

importarcsvporcampo.zipFetching info...

[guest*]

Spanish no problem, I speak it as well. I will try this and report. Thxs. for your the hint.

[philee]

Did anyone got this working for their site?

[guest*]

Not for me. I use Prestashop Manager to do this.

[philee]

Can you update the quantity with two fields, "Product ID and Quantity field"?

[guest*]

Yes, you can map to any row or table you want to have an update. You can try Prestashop Manger 30 days for free. Link you will find in prestashop add-ons banner. Third or fourth option in the banner.

[ankit@softdew.co.in]

can anybody guide me how to make csv file for importing product and the complete process of importing

im using prestashop 1.4.7.0

[shiggidydog]

Hi,

 

I had an employee create a script for me that allows me to upload a .CSV file based upon product reference ids to update inventory stock. It's still relatively simple and we don't have any plans to develop it any further. I wanted to sell it on add-ons because it saved me sooo much time and I'm sure other people could use it. The only thing is that we had to pay for his salary to create it and I'd like to recoop a little bit of our expense.

 

Unfortunately prestashop add-ons won't let me sell it unless i make it into a full fledge module and we lack the expertise to do it. Right now its just a simple replacement of 2 files in your admin folder, and copy two other files. I've attached the instructions for it, if someone wants to donate some money for it, I'll glady share it Your choice of how much to donate. Send me a PM if you're interested.

 

Thanks!

mass inventory update.pdfFetching info...

[yourplaything]

  On 8/5/2012 at 10:31 AM, shiggidydog said:

Hi,

 

I had an employee create a script for me that allows me to upload a .CSV file based upon product reference ids to update inventory stock. It's still relatively simple and we don't have any plans to develop it any further. I wanted to sell it on add-ons because it saved me sooo much time and I'm sure other people could use it. The only thing is that we had to pay for his salary to create it and I'd like to recoop a little bit of our expense.

 

Unfortunately prestashop add-ons won't let me sell it unless i make it into a full fledge module and we lack the expertise to do it. Right now its just a simple replacement of 2 files in your admin folder, and copy two other files. I've attached the instructions for it, if someone wants to donate some money for it, I'll glady share it Your choice of how much to donate. Send me a PM if you're interested.

 

Thanks!

 

I have looked at your PDF file and im interested ! Really need something that works as everything i have tried does not ! Please help !