Edit History

I don't need an automatic direct import form from my vendor's site, I have to upload the file manually. My provider does not allow automatic import.

So I load the XML file on the prestashop 1.7.5 module, and the module must convert the data previously indicated.

I tried a lot of modules, but nobody satisfied me. The only one that allows me to automate these conversions is eMagicOne Store Manager, but there is a need for software installed on the PC and it is bound to this.

If you have the prestashop native import module in mind I would like you to do the same thing, with the only addition that would modify some fields and insert the missing fields.

 

Attachment example files on XLSX

first 2 lines are empty then skip
 

02.5954

APPLE

no EAN then skip

01.633

ASUSTEK

4712900152609

90SV04EA-M02CE0

rename ASUSTEK to ASUS

15.400	BROTHER	EGS60MF
89.1160	COOLER MASTER	0000000000000	10CMFR0000002

Wrong EAN then SKIP

47.1930

POLAROID

4250175825014

TORCIA "SPELEOLOGO" A 7 LED POLAROID '3XBATTERIE AAA' >(NON INCLUSE)< 4250175825014/717-825014\

Wrong name then RENAME to Manufacter + EAN

 

• If product exist on prestashop by EAN update price and Quantity
• disponibilità_filiale is Quantity
• Disponibilità_sede is 0 and disponibilità_sede is 0 import but disable
• Disponibilità_sede is 0 and disponibilità_sede is 0 update price and quantity

The module don't must delete existing product without EAN on my prestashop
i have icecat import then all other data was update by icecat by a cronjob

 

Please send me a mail with

• Your cost
• Your office address
• Time to enable module
• Payment method

 

example.xlsx

I don't need an automatic direct import form from my vendor's site, I have to upload the file manually. My provider does not allow automatic import.

So I load the XML file on the prestashop 1.7.5 module, and the module must convert the data previously indicated.

I tried a lot of modules, but nobody satisfied me. The only one that allows me to automate these conversions is eMagicOne Store Manager, but there is a need for software installed on the PC and it is bound to this.

If you have the prestashop native import module in mind I would like you to do the same thing, with the only addition that would modify some fields and insert the missing fields.

 

Attachment example files on XLSX

first 2 field are empty then skip
 

02.5954

APPLE

no EAN then skip

01.633

ASUSTEK

4712900152609

90SV04EA-M02CE0

rename ASUSTEK to ASUS

15.400	BROTHER	EGS60MF
89.1160	COOLER MASTER	0000000000000	10CMFR0000002

Wrong EAN then SKIP

47.1930

POLAROID

4250175825014

TORCIA "SPELEOLOGO" A 7 LED POLAROID '3XBATTERIE AAA' >(NON INCLUSE)< 4250175825014/717-825014\

Wrong name then RENAME to Manufacter + EAN

 

• If product exist on prestashop by EAN update price and Quantity
• disponibilità_filiale is Quantity
• Disponibilità_sede is 0 and disponibilità_sede is 0 import but disable
• Disponibilità_sede is 0 and disponibilità_sede is 0 update price and quantity

i have icecat import then all other data was update by icecat by a cronjob

 

Please send me a mail with

• Your cost
• Your office address
• Time to enable module
• Payment method

 

example.xlsx

I don't need an automatic direct import form from my vendor's site, I have to upload the file manually. My provider does not allow automatic import.

So I load the XML file on the prestashop 1.7.5 module, and the module must convert the data previously indicated.

I tried a lot of modules, but nobody satisfied me. The only one that allows me to automate these conversions is eMagicOne Store Manager, but there is a need for software installed on the PC and it is bound to this.

If you have the prestashop native import module in mind I would like you to do the same thing, with the only addition that would modify some fields and insert the missing fields.

 

Attachment example files on XLSX

first 2 field are empty then skip
 

02.5954

APPLE

no EAN then skip

01.633

ASUSTEK

4712900152609

90SV04EA-M02CE0

rename ASUSTEK to ASUS

15.400	BROTHER	EGS60MF
89.1160	COOLER MASTER	0000000000000	10CMFR0000002

Wrong EAN then SKIP

 

 

47.1930

POLAROID

4250175825014

TORCIA "SPELEOLOGO" A 7 LED POLAROID '3XBATTERIE AAA' >(NON INCLUSE)< 4250175825014/717-825014\

Wrong name then RENAME to Manufacter + EAN

 

example.xlsx

I don't need an automatic direct import form from my vendor's site, I have to upload the file manually. My provider does not allow automatic import.

So I load the XML file on the prestashop 1.7.5 module, and the module must convert the data previously indicated.

I tried a lot of modules, but nobody satisfied me. The only one that allows me to automate these conversions is eMagicOne Store Manager, but there is a need for software installed on the PC and it is bound to this.

If you have the prestashop native import module in mind I would like you to do the same thing, with the only addition that would modify some fields and insert the missing fields.

 

Attachment example files on XLSX

first 2 field are empty then skip
 

02.5954

APPLE

no EAN then skip

01.633

ASUSTEK

4712900152609

90SV04EA-M02CE0

rename ASUSTEK to ASUS

15.400	BROTHER	EGS60MF
89.1160	COOLER MASTER	0000000000000	10CMFR0000002

Wrong EAN then SKIP

 

 

47.1930

POLAROID

4250175825014

ILLUMINAZIONE

TORCE A BATTERIA

TORCIA "SPELEOLOGO" A 7 LED POLAROID '3XBATTERIE AAA' >(NON INCLUSE)< 4250175825014/717-825014\

Wrong name then RENAME to Manufacter + EAN

 

example.xlsx