Priya’s supplier sent a new price list every Monday. Manually updating 500 products meant copying prices, changing stock levels, and rewriting descriptions. Every Tuesday, Priya was exhausted, and customers were angry about outdated “In Stock” labels.

Arjun explained: “The built-in tool is just a skeleton. You need a strategy.”

Her developer friend, Arjun, said: “Stop editing in the admin panel. You need an OpenCart data import workflow.”

The Great Product Migration (Or: How Sleepless Nights Turned into Scheduled Imports)

Now, go forth and import like Priya – without tears, without fear, and with plenty of time left for chai.

Images were always a problem. Arjun explained: “OpenCart doesn’t import images from a URL. It needs the image filename and the file already in the image/catalog/ folder.” They created a simple batch upload via FTP, then in the CSV, they just put: catalog/spices/cinnamon.jpg in the image column.

For 500 products, Arjun recommended a free extension called “Import/Export Ultimate” (or similar). But even without an extension, he showed her how to use phpMyAdmin for pure SQL imports – but warned: “Only if you know what a foreign key is.” Instead, she used a simple Python script (using csv and requests ) to validate the CSV before import.