[RELEASED] Export/Import tool for OpenCart 1.5.3.x

baillie11 wrote:Hi,

I have downloaded opencart-1-5-4-x-export-import-13.zip for OpenCart 1.5.4.1 and have been able to export without any problems, however, when I import products, I receive a message saying it has worked, however, none of the products appear in the admin-catalog-products area, nor on the front end.

I have checked and error logs in VQModManager & System-Error Logs and have even cleared them.

I have opened cart in different browser (in case the cache hasn't cleared properly). I even exported the data back out and it still doesn't appear in the spreadsheet.

Any suggestions on what I could be doing wrong (im presuming it me, not your software - lol).

Thanks

Andrew

meggabecca wrote:Hi

Because of memory issues, I spilt my spreadsheets into sections, but the problem is everytime I upload a spreadsheet, it gets rid of all the other products, so now back to square one, it seems most have memory problems this rubbish, can anyone suggest something else other than paying out £30 per month for dedicated server, which seems extreme, and can not validate paying that, so any other suggestions of finding a work around, to solve these memory issues...

Thanks in Advance

tidusbg wrote:Hello!

Could you send or show me one .xls file ready to Import (with one or more products).
I can't make xls file which is Ok for Import.
I just need to see one corectly made.

Thanks in advance.

JNeuhoff wrote:

tidusbg wrote:Hello!

Could you send or show me one .xls file ready to Import (with one or more products).
I can't make xls file which is Ok for Import.
I just need to see one corectly made.

Thanks in advance.

Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.

<b>Notice</b>: Error: Table '.........oc_product_tag' doesn't exist<br />Error No: 1146<br />SELECT   p.product_id,  pd.name,  GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories,  p.sku,  p.upc,  p.location,  p.quantity,  p.model,  m.name AS manufacturer,  p.image AS image_name,  p.shipping,  p.price,  p.points,  p.date_added,  p.date_modified,  p.date_available,  p.weight,  wc.unit,  p.length,  p.width,  p.height,  p.status,  p.tax_class_id,  p.viewed,  p.sort_order,  pd.language_id,  ua.keyword,  pd.description,   pd.meta_description,   pd.meta_keyword,   p.stock_status_id,   mc.unit AS length_unit,   p.subtract,   p.minimum,   GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related,   GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id   AND pd.language_id=2 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oc_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oc_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id   AND wc.language_id=2 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id   AND mc.language_id=2 LEFT JOIN `oc_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `oc_product_tag` pt ON pt.product_id=p.product_id   AND pt.language_id=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;  in <b>public_html/openchart/system/database/mysql.php</b> on line <b>50</b>

tidusbg wrote:

Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.

When i export xls I recive this massage in xls file:

<b>Notice</b>: Error: Table '.........oc_product_tag' doesn't exist

JNeuhoff wrote:

tidusbg wrote:
Do an Export first, and use the resulting spreadsheet to overwriteitwith your own values. Then import it.

When i export xls I recive this massage in xls file:

Code: Select all

<b>Notice</b>: Error: Table '.........oc_product_tag' doesn't exist<br />Error No: 1146<br />SELECT   p.product_id,  pd.name,  GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories,  p.sku,  p.upc,  p.location,  p.quantity,  p.model,  m.name AS manufacturer,  p.image AS image_name,  p.shipping,  p.price,  p.points,  p.date_added,  p.date_modified,  p.date_available,  p.weight,  wc.unit,  p.length,  p.width,  p.height,  p.status,  p.tax_class_id,  p.viewed,  p.sort_order,  pd.language_id,  ua.keyword,  pd.description,   pd.meta_description,   pd.meta_keyword,   p.stock_status_id,   mc.unit AS length_unit,   p.subtract,   p.minimum,   GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related,   GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id   AND pd.language_id=2 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oc_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oc_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id   AND wc.language_id=2 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id   AND mc.language_id=2 LEFT JOIN `oc_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `oc_product_tag` pt ON pt.product_id=p.product_id   AND pt.language_id=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;  in <b>public_html/openchart/system/database/mysql.php</b> on line <b>50</b>

maney wrote:Hey,

Installed on 1.5.5 and I'm getting this error, can you help?

Fatal error: Call to undefined method Loader::language() in /var/sites/r/reliablereptile.co.uk/public_html/admin/controller/tool/export.php on line 6

Thanks!