I need to import the category to each product, but my vendor only supplies the relations in "id". Is there a way import "virtuemart_category_id" and "virtuemart_product_id" in the same template?
Thanks
same with manufacturing id -- it would do the trick if they can be exported and imported in the same file. thanks again :)
Hello,
Are the relations "ids" going to be VM ids? will your vendor database and your database would match by doing id importing?
It is not recommended to use Id fields for importing but use category_path, manufacturer_name and product_sku. This way a new entry will be created in database table when a new category or manufacturer or product is detected in your csv file.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi,
Thanks for your reply. I thought the "ids" somehow had to match because in the csv`s they supply refers to products, categories and manufacturers as "ids".
What I mean is - is there a way to possibly adapt this to csvi?
thanks again
I mean is it possible*
Hello,
I think we need to clear something up. The IDs given by your supplier are not related to the IDs in your Joomla installation. I would assume that your supplier has multiple files that relate to each other based on these IDs.
In a database the IDs are controlled by the database and as users we shouldn't really be modifying them, that is why it is not recommended to alter the IDs. It is better to use the real names for the manufacturers, products and categories. CSVI will make sure the data integrity is kept.
As a final note, if you import the IDs and the item doesn't exist yet, Joomla will do an update regardless if it exists or not. If it doesn't exist, it will show as nothing has happened. That is all because it is the primary key.
I think you will have to create a single file of all these separate CSV files that contains the correct info without the IDs.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks for clearing this up. I`m getting in touch with the supplier. Thanks again
Log in to reply to this topic.