Page 1 of 1

Product Quantity update from CSV

Posted: Mon Oct 24, 2011 10:19 am
by ner0tik
i'm looking for an extension that will allow me to update product quantities from a spreadsheet like http://www.opencart.com/index.php?route ... oad_id=748 but unfortunately that extension hasn't been updated since 1.4.7. i tried making it 1.5.x compatible but my knowledge of php is pretty much non existent.. i was wondering if someone would be willing to fix that extension so it works with 1.5.x or point me in the direction of another extension that can do what i need. thanks in advance.

Re: Product Quantity update from CSV

Posted: Wed Oct 26, 2011 5:35 am
by Maaris
I made a csv file and a simple php script, that I upload to server, execute and delete. Guess you can do a similar solution here.

Re: Product Quantity update from CSV

Posted: Fri Nov 25, 2011 2:38 am
by Nija
Can i get your simple php file ?
Thx

Re: Product Quantity update from CSV

Posted: Fri Nov 25, 2011 4:50 am
by straightlight
Fixed and compatible with OpenCart v1.5x. Download the file from my attachment and upload it to your admin/controller/tool folder then try again from the admin. Overwrite the old file / remove it if you already uploaded the previous one from the ZIP package distributed by this author.

Edit: Another file to edit is admin/controller/common/header.php file.

Replace:

Code: Select all

$this->data['inventory_update'] = HTTPS_SERVER . 'index.php?route=tool/inventory_update'; 
With:

Code: Select all

$this->data['inventory_update'] = $this->url->link('tool/inventory_update', 'token=' . $this->session->data['token'], 'SSL');