Post by zaidladha » Wed Feb 20, 2019 4:12 am

Hi,

opencart 2.3.0.2

Uber CSV exports and imports the specials table in the database. I want to include the column "Sku" from the product table directly into the specials table.



Unless you have a better solution:
I have a spreadsheet with specials I export from my internal system (4 columns: sku, price, start date, end date). I need to update the specials on my website (over 80,000 products, perhaps between 5-10k specials per user group). The only common column is the sku. I have currently added the word "sku " before any sku number to avoid losing lead in zeroes, not all items from my internal system are online so there are some extra sku numbers.

Can anyone help? I figure there's gotta be an easier way than my way.

Active Member

Posts

Joined
Wed Jun 05, 2013 3:07 pm

Post by straightlight » Wed Feb 20, 2019 6:24 am

For 80000 products, at this magnitude, I would recommend creating a service request in the Commercial Support section of the forum to get this done as a custom job.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com Administrator / Quality Assurance Analyst / Programmer


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 39 guests