Hello,
i am happy for finishing my work makeing a template with my fields.
no i wanted to import and looked at the preview, everything looks good, but i have an error:
Duplicate entry '2' for key 'PRIMARY' SQL=UPDATE qtq7l_virtuemart_products SET virtuemart_product_id='2',virtuemart_vendor_id='1',product_parent_id='0',product_gtin='',product_mpn='',product_weight_uom='KG',product_lwh_uom='M',product_url='',product_in_stock='999',product_ordered='0',low_stock_notification='0',product_available_date='2015-10-07 00:00:00',product_availability='',product_special='0',product_sales='0',product_unit='Stck',product_packaging='1',product_params='min_order_level="0"|max_order_level="0"|step_order_level=""|product_box="0"|',intnotes='',metarobot='Duftkalender, Kalender A3, Wandkalender, Kalendergeschenk, Cocktails',metaauthor='',layout='0',published='1',pordering='0',created_on='2015-10-07 14:19:25',created_by='930',modified_on='2015-10-14 12:16:48',modified_by='930',locked_on='0000-00-00 00:00:00',locked_by='0' WHERE product_sku='K0001'
CSVI Pro 6.2.0 | Copyright (C) 2006 - 2015 RolandD Cyber Produksi
Where can i say to override the products like in the free version?
Thank you very much for your help.
Brigitte
i found some proucts in the database without the language-code and deletet then. now i have another error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND product_currency IS NULL) AND product_price_publish_up = '0000-00-00 0' at line 3 SQL=SELECT virtuemart_product_price_id FROM qtq7l_virtuemart_product_prices WHERE virtuemart_product_id = 9 AND price_quantity_start = 0 AND price_quantity_end = 0 AND virtuemart_shoppergroup_id IS NULL) AND product_currency IS NULL) AND product_price_publish_up = '0000-00-00 00:00:00' AND product_price_publish_down = '0000-00-00 00:00:00'
and now all the existing articels ar still in the database, but i dont see at frontend and backend
He importet the first line in the database without the countrycodes. i said skip the first line.
Please help me
Brigitte
Hello Brigitte,
Where can i say to override the products like in the free version?
Existing products are automatically updated.
This error has been posted as a sticky topic, see here for the solution.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
i installed the fix and now i have the error
Duplicate entry 'duftkalender-dancin-cocktail' for key 'slug' SQL=INSERT INTO qtq7l_virtuemart_products_de_de (virtuemart_product_id,slug) VALUES (12, 'duftkalender-dancin-cocktail')
And i dont see any of my prodcts in backend and frontend. But there are in the database.
i see that he write 1 article into the databas products without the language code.
i did not installed anything i only importet my products, We also can make the shop not multilanguage. Is this better, but i dont know how to set this, because if i set the plugin language disable and make a new import, i also don't see anything.
Please help me.
Brigitte
Hello Brigitte,
You don't need to make the shop multi-lingual, the fact that the products are stored in the de_de table means, you are storing products in German. This means you must also access the site in German otherwise VirtueMart won't show the products.
As for the duplicate slugs, this can happen when you have duplicate product names. You can load this patch and that should deal with the slugs.
i see that he write 1 article into the databas products without the language code.
What do you mean by that?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.