Resolved There are no products when I imported a file

Hello,
You need to send us your import debug log to check what is happening with your import. Your screenshot shows that your debug log is not enabled in your template. Have a look at "Where to get the debug information?" section on top of this page to know how to get your debug log and post it here.

I know the reason.

The issue is that Products are at least in 2 tables! virtuemart_products and virtuemart_products_your-language.
Importing products by csvi are going into virtuemart_products_your-language table. But when there is no entry in virtuemart_products table with the same id with virtuemart_products_your-language table the product will not show. So you have product in your data base.
The solution is to create in admin empty product with some name (for example test name) and sku and save it. You will have product in virtuemart_products. Then when you import products with correct id and sku with virtuemart_products table - Products will show in store.

But i would like to know How to create Products by csvi without adding manually empty product??

Hello,
The reason you are saying is not possible with CSVI import, CSVI will first create an entry in virtuemart_products table and using the virtuemart_product_id generated from this table it creates the entry in virtuemart_products_your-language table. As requested in previous message you need to send us your import debug log and sample import file to check.

Where i can send it ?

You can post it here or send it as a private message.

done

Hello,
I see a problem with your import file, you have used virtuemart_product_id field in your import file, you should not be using it as it is a primary key field and using it will only try to run update query for products. Your debug log has these update queries for both virtuemart_products and virtuemart_products_your-language table. CSVI identifies if a product is in database using product_sku field and since you have virtuemart_product_id it has tried to update a product with id 474. Please remove virtuemart_product_id field from your import file and try doing the import.

So i should use only sku and id will be automaticly added in data base?

yes, virtuemart_product_id is a unique and auto increment field. It will be automatically created and added.

Thanks!

i think that renta_web had similar issue.

Can you tell me how to delete id from data base? When i make a test order or add test product there is autoicrement id as you said. for example i added product with id 474. Delted that. And when i add another product it has id 475. How to madke 474 again?

Regards.

Hello,

i think that renta_web had similar issue.

I dont think so, his screenshot of import preview dont show use of virtuemart_product_id in his import. We would need to check his debug log to find the issue.

Can you tell me how to delete id from data base? When i make a test order or add test product there is autoicrement id as you said. for example i added product with id 474. Delted that. And when i add another product it has id 475. How to madke 474 again?

One way is you can change the virtuemart_product_id by going to phpmyadmin and edit the id to 474. But you need to make sure you edit it in both virtuemart_product and virtuemart_product_lang table.

Thanks,

i found a better way.

In php my admin i enter into virtuemart_product table ---> operations and on table oprtions i make down autoincrement field it`s just a pity i can`t change it from backend of joomla.

regards

Hello,

I don't understand the obsession with IDs. These IDs are meant to managed by the database and not by you. If you really want to use an ID, why not use the GTIN or MPN field and store your own ID in that field. You can set in your template to use that field to update. The internal ID (virtuemart_product_id) would then still be maintained by the database and you can handle your own ID.

Hello,

it`s just a pity i can`t change it from backend of joomla.

The auto increment fields are primary key field of database tables and their values are unique so to identify a record, we don't have any control on it nor should be having. It has to be managed by database as any change in these fields will lead to messed up records in database tables. No software give access or control to these fields nor its values.

Good question. I think it`s because people get used with this id`s. In my case it`s because i worked some time ago in e-commerce bookstore and there id`s was most important thing. Software Microsoft Otpima which managed orders was based on id`s.
PS - how to add this GTIN or MPN fields in VM ?


regards

Hello,

In my case it`s because i worked some time ago in e-commerce bookstore and there id`s was most important thing.

Books would be using ISBN rather than database IDs. However I think there is a miscommunication with the word ID. The IDs in Microsoft Optima may not have been the auto-increment ID of the database but another ID. Let's call it the internal ID, that is the ID you don't want to mess with. The product SKU (Stock Keeping Unit) is also a unique ID. An ID can be anything from just numbers to a alphanumeric values of course. That is why I recommend using your own ID system rather than dealing with the internal ID system.

PS - how to add this GTIN or MPN fields in VM ?

You don't have to, they already exist. If you edit a product, these fields are there. If you don't use the product SKU field, you can use that as well.