Hello,
I already have 367 products in virtuemart.
I have to import another 350 products.
The categories are already present in virtuemart.
I configure the template to export the products in csv, following the example of the demo.
I add the following fields:
virtuemart_product_id
product_sku
product_name
product_desc
product_price
category_path
FILE_URL
published
product_in_stock
product_parent_id
custom_title
custom_value
I open the csv file with Notepad ++, I copy the last line and I paste it immediately after, I change virtuemart_product_id (from 603 to 604) and the product_sku.
I create the template for the import, I configure it following the example of the demo, inserting "virtuemart_product_id" in "Import based on", I insert the same fields of the template for the export, I import the file, the import goes successful.
The product is not seen on the site, and I do not even see it in the back-end.
Prices have disappeared in the front-end (the "call for price" button appears)
I open the MySql database and I see that the record has been added to the "virtuemart_products_it_it" table. No records have been added to the "virtuemart_products" table.
Do I have to create other templates to add all the products correctly?
Thanks
Pio
Accepted Answer
Pending Moderation
Hello,
I uploaded an old copy of the site database, because I did not activate the "Enable logging" option, so I did not generate the log file.
I have corrected the template configurations, and in the template for the import, I entered "product_sku" in the "Import based on" option.
I have to import parent products and child products (sizes).
The "virtuemart_product_id" field is used to let me know the id of the parent product and to associate it with the child product.
For example, if I have to import the parent product with product_sku "PIO659" and 6 sizes (in Italian "Size"
I have to enter the id of the parent product in the "product_parent_id" field (see attachment).
product.csv
If I do not have to touch the fields that end with _id, how can I import parent and child products?
Thanks
Pio
I uploaded an old copy of the site database, because I did not activate the "Enable logging" option, so I did not generate the log file.
I have corrected the template configurations, and in the template for the import, I entered "product_sku" in the "Import based on" option.
I have to import parent products and child products (sizes).
The "virtuemart_product_id" field is used to let me know the id of the parent product and to associate it with the child product.
For example, if I have to import the parent product with product_sku "PIO659" and 6 sizes (in Italian "Size"
I have to enter the id of the parent product in the "product_parent_id" field (see attachment).product.csv
If I do not have to touch the fields that end with _id, how can I import parent and child products?
Thanks
Pio
Accepted Answer
Pending Moderation
Hello,
I deleted the "virtuemart_product_id" and "product_parent_id" field, and entered the product_parent_sku field and the "Taglia" (size in the Italian language) field (see product.csv ).
I imported the product.csv file, the parent product and the children were correctly inserted, but the fields in the custom fields are missing (see
).
Custom fields should appear as in the example (
).
Which fields do I need to import to also display custom fields?
com_csvi.log.66.zip
I deleted the "virtuemart_product_id" and "product_parent_id" field, and entered the product_parent_sku field and the "Taglia" (size in the Italian language) field (see product.csv ).
I imported the product.csv file, the parent product and the children were correctly inserted, but the fields in the custom fields are missing (see
Custom fields should appear as in the example (
Which fields do I need to import to also display custom fields?
com_csvi.log.66.zip
Accepted Answer
Pending Moderation
Hello,
I entered the "custom_multiple" field (see product.csv ), the custom fields have been inserted, but the values (the sizes) are missing (see
).
Thanks
Pio
I entered the "custom_multiple" field (see product.csv ), the custom fields have been inserted, but the values (the sizes) are missing (see
Thanks
Pio
Accepted Answer
Pending Moderation
Hello,
I imported the file without the "size" field, the parent product and the child products were inserted correctly.
In the back-end, the information concerning the product has been inserted all, the custom fields are present.
In the front-end, in the category "BERRETTO TESSUTO", http://lnx.cappelleriaartigianale.it/index.php/uomo/uomo-invernale/berretto-tessuto,
there are six child products of the parent product "PIO659"
Instead the parent product should be present, by clicking on it the user must be able to choose the sizes, as happens with the products entered manually.
and
Thanks
Pio
I imported the file without the "size" field, the parent product and the child products were inserted correctly.
In the back-end, the information concerning the product has been inserted all, the custom fields are present.
In the front-end, in the category "BERRETTO TESSUTO", http://lnx.cappelleriaartigianale.it/index.php/uomo/uomo-invernale/berretto-tessuto,
there are six child products of the parent product "PIO659"
Instead the parent product should be present, by clicking on it the user must be able to choose the sizes, as happens with the products entered manually.
and
Thanks
Pio
- Page :
- 1
- 2
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!