XJR100 Posted June 1, 2010 Share Posted June 1, 2010 Hello!I have found some difficulties with syncronising data in PrestaShop and another warehouse/bookeeping software.First is what I've found, that ID for group and product for new imported products is assigned automatically and it's type "number". So, I cannot find how to import groups and goods with ID from my software.So, let's say, in my software I have Group ID "GR000138" and Product ID "MCAP400-3.3"- I can Export files - groups only and products only and will have 2 files: groups.csv and products.scv with the following content:groups.csv:----------------------------------Parent; GroupID; Description1;GR000138;MCap 400V Capacitors1;GR000139;MCap 250V Capacitors----------------------------------products.csv:----------------------------------Parent; ProductID; DescriptionGR000138;MCAP400-3.3;MCAP 3.3uF Capacitor 400VDCGR000139;MCAP250-3.3;MCAP 3.3uF Capacitor 250VDC----------------------------------This structure I cannot import to prestashop:It imports groups OK; but I get as groupID something automatically assigned like "2" instead of "GR000138"If then I'll try to import products.csv - it creates new group with another ID and name "GR000138" and product goes there.I have found the only possibility to import my structure is to rename all product and group IDs in my software and put them same numerical ID what it gets in prestashop.Any Ideas how Prestashop can use as ProductID and group ID same names I already have in my software (like "G000138", "Mcap400-3.3", and similar)?Thanks! Link to comment Share on other sites More sharing options...
XJR100 Posted June 22, 2010 Author Share Posted June 22, 2010 Hi!Any answers? Link to comment Share on other sites More sharing options...
MrBaseball34 Posted June 28, 2010 Share Posted June 28, 2010 This is going to take a custom import process. We had to write one specifically for our site because of the vendor file.I could probably do it for you for a nominal fee since I am a programmer. Link to comment Share on other sites More sharing options...
XJR100 Posted June 28, 2010 Author Share Posted June 28, 2010 This is going to take a custom import process. We had to write one specifically for our site because of the vendor file.I could probably do it for you for a nominal fee since I am a programmer. I'm interested.How it will be implemented? as special "import module"?What it will cost?Thanks! Link to comment Share on other sites More sharing options...
MrBaseball34 Posted June 28, 2010 Share Posted June 28, 2010 Ours is a separate script and runs on a cron job to update our inventory every week.I'm not sure, it would depend on your vendor file(s). Link to comment Share on other sites More sharing options...
MrBaseball34 Posted June 28, 2010 Share Posted June 28, 2010 PM me with your email and we'll discuss off-line. Link to comment Share on other sites More sharing options...
XJR100 Posted August 25, 2010 Author Share Posted August 25, 2010 Any Ideas how Prestashop can use as ProductID and group ID same names I already have in my software (like "G000138", "Mcap400-3.3", and similar)? Still unsolved... Link to comment Share on other sites More sharing options...
jhnstcks Posted August 25, 2010 Share Posted August 25, 2010 Any id's used in prestashop are numerical and cannot include any letters of symbols, i expect thats why the import is failing. Link to comment Share on other sites More sharing options...
MrBaseball34 Posted August 25, 2010 Share Posted August 25, 2010 That's true but the import uses autoincrement to create id_product values. The "ProductID" that you import can go in the reference column of ps_product or as a feature value. We actually place it in both in our import process. We do not use the included CSV import. Link to comment Share on other sites More sharing options...
XJR100 Posted August 25, 2010 Author Share Posted August 25, 2010 OK, thanks for the info.Looks like it'seasy to create im my warehouse software additional numerical code_field and use it as ID for importing products in PrestaShop. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts