I am working on this new web site it uses OpenCart Version 126.96.36.199
There is a company going to drop ship for me, they gave me their product info & I put it in to a xls sprdsht to import in to the site to populate the site but it is not working. It took me an hour just to get it into the product format for this tool below to upload to the site:
I got this free opencart extension called
Export/Import Tool to upload this feed in to the web site:
[url removed, login to view]
So if you have a opencart site you would login to the admin go to System > Export/Import & choose the file to upload.
I have attached the xls sprdsht, all the info is in the product table.
Anyway I am getting an error message when I try & upload the xls sprdsht, the products won't load, I am getting this error on the top of the page in Internet Explorer 7 & Safari it just keeps loading for hours & never works.
Notice: Undefined variable: formatstr in /hsphere/local/home/c318638/[url removed, login to view] on line 635Notice: Undefined variable: formatstr in /hsphere/local/home/c318638/[url removed, login to view] on line 635Notice: Undefined variable: formatstr in /hsphere/local/home/c318638/[url removed, login to view] on line 635Notice: Undefined variable: formatstr in /hsphere/local/home/c318638/[url removed, login to view] on line 635Error: Unknown column 'LPMP' in 'field list'
Error No: 1054
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`,`cost`) VALUES (0331-LPMP,99,'812487010591','0',7,'A101-5',1,'[url removed, login to view]',1,39.86,NOW(),NOW(),NOW(),2,5,1,0,0,0,0,0,'3','0','1','0',29.97);
This tool does work, I have tested it for small uploads, but not taking this file I have attached.
So I don't know if it is the upload tool, the way the file is formatted or what ?
I also tried just uploading only the1st prdt in the sprdsht the way it is but still get error message, it doesn't like the formatting somewhere ?
I will be updating the site probably weekly with their products datafeed, so I need to get this fixed once and for all, so I would need FULL DOCUMENTATION on what you did to fix it so it doesn't keep happening & I can upload it on a weekly basis to my site.
You may have to setup a test opencart site to see how it works.
So give me a quote on the cost, go easy on me, if goes well, other projects avail.
Also is there a better tool out there I can use with opencart for importing and exporting products out there I should use ?
Also need to install this extension VQMOD 1.0.8 from [url removed, login to view] it is suppose to be real easy to install but I am not a programmer, so I need this installed on 2 sites & full instructions & copy of file on how you did it & how to use it. So I can install it myself a non programmer.