Custom Php Script
Posted: Wed May 15, 2019 7:13 am
Hi,
I want to have a custom php script written that will update special prices.
Background:
Product data base of 80,000 items. Approximately 10,00 have the field sku filled out.
I will export a file from my ERP in csv format. (sku, price, start date, end date)
I want to import the sales from the ERP using the index "sku" to my opencart site. The sku field is not currently indexed in the specials table.
It needs to generate the same price for all customer groups.
In opencart I have the word "sku" before every sku so that when I export it, it does not remove lead in zeroes. I do not have that built in from my ERP, but likely can.
I can manually place the csv file from my ERP in particular folder that the php script can access.
Please let me know how much, and what access you need. Ideally you would write the script, I would test it on my test server.
I want to have a custom php script written that will update special prices.
Background:
Product data base of 80,000 items. Approximately 10,00 have the field sku filled out.
I will export a file from my ERP in csv format. (sku, price, start date, end date)
I want to import the sales from the ERP using the index "sku" to my opencart site. The sku field is not currently indexed in the specials table.
It needs to generate the same price for all customer groups.
In opencart I have the word "sku" before every sku so that when I export it, it does not remove lead in zeroes. I do not have that built in from my ERP, but likely can.
I can manually place the csv file from my ERP in particular folder that the php script can access.
Please let me know how much, and what access you need. Ideally you would write the script, I would test it on my test server.