Resolved VirtueMart Product ID and Category ID

Thanks for clearing this up. I`m getting in touch with the supplier. Thanks again

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.

I mean is it possible*

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

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.

same with manufacturing id -- it would do the trick if they can be exported and imported in the same file. thanks again