Post by robbie123 » Tue Jul 31, 2012 6:27 pm

When trying to export I get the following:
'Warning: set_time_limit(): Cannot set time limit due to system policy in /customers/9/5/f/schlosser.co.uk/httpd.www/upload/admin/controller/tool/export.php on line 76Notice: Error: Unknown column 'cg.name' in 'field list'
Error No: 1054
SELECT ps.*, cg.name FROM `product_special` ps LEFT JOIN `customer_group` cg ON cg.customer_group_id=ps.customer_group_id ORDER BY ps.product_id, cg.name in /customers/9/5/f/schlosser.co.uk/httpd.www/upload/system/database/mysql.php on line 49'


Can anyone shed any light, i've searched the forums and found a similar post but no solution was posted.

Also, when importing I get 'Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!'

Im fairly new to Opencart and the Export/Import extension so any help would be much appreciated! I have almost 2000 products that I need to add to my product list! I presume there must be a set format for the spreadsheet in order for the import tool to work properly?

Thanks in advance.

Newbie

Posts

Joined
Tue Jul 31, 2012 6:18 pm

Post by justinv » Thu Aug 02, 2012 7:21 am

There's a very specific format required for the free import/export tool. Make an export using the tool, and use that to format your own products.

The first error is due to your webhost not allowing you to increase the time limit for the script.

For a more flexible tool that will take a CSV file checkout the CSV or Total Import PRO modules in my signature.

Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Image


Active Member

Posts

Joined
Tue Oct 12, 2010 1:24 pm
Who is online

Users browsing this forum: No registered users and 3 guests