Resolved Virtuemart export of products from one manufacturer

Hello Daniel,
You can Skip import of specific records using RO CSVI Skip rule plugin. This rule needs a specific value in records so that RO CSVI can identify the row with that value and Skip it on import. Do you have any such field value in your export file?

Hello again,

I would like to import only selected products from export file, can you please advice how I could do it or how can I edit csv file ?

Thank you,
Daniel

Hello RolandD,

I have just done what you have advised so changed virtuemart_vendor_id for related_products from 1 to 0 on export site and import site. On the first time it didnt work, then I have deleted all imported products and started again and since its working fine.

Thank you very much for your help !

Kind regards,
Daniel

Hello Daniel,

Would you mind telling us how you solved it?

Hello again,

thank you for your support, I have solved the issue.

kind regards,
Daniel

Hi Tharuna,

I have changed virtuemart_vendor_id for related_products from 1 to 0 on export site and import site, but still same problem.

See attached print screen.

Regards,
Daniel

Hello Daniel,
As per the debug log, related products are not processed. In your database look for #__virtuemart_customs (#_ replaced by table prefix) table and in that check the value of virtuemart_vendor_id field for related products record. It should be set to 0. In some cases the value is 1 and that would cause trouble in updating related products. Let me know if that helps.

If you still have problem please post screenshot of related products row from #__virtuemart_customs table.

Hello,

attached are debug logs from export and import. I can see related_products listed under preview but they are not visible after import in Virtuemart under section Custom fields / Related Products ...



Kind regards,
Daniel

Hello Daniel,

Are you asking why you see the related_products in the preview? If you want us to check why related_products are not importing, please post the debug log for us to check.

Hi Tharuna,

sorry to bother you again, have an issue with importing related products, I have used field related_products in export file, also in import file, but products are missing. I have deleted related_products field from Import, but no change. I can see related products (sku numbers listed in file (preview) ... see attached, products with those sku numbers are also imported.

Any idea what is wrong ?

Thanks,
Daniel

Hello Daniel,
Final price field is not something RO CSVI calculates on import. It is calculated by VirtueMart on product page load and is not saved anywhere in database. I also noticed that you have two different rules DPH in your export and AFA in import as per your screenshot. That will also have effect on the prices.

Hi Tharuna,

attached please find rule settings. The final price is incorrectly calculated - see attached file "export_import.jpg"

Attached are also logs from export / import.

Kind regards,
Daniel

Hello Daniel,
Can you tell us in detail with an example what is not working? Screenshots does not tell me anything. What is the rule you have applied in your export fields for product_price and product_override_price? What does the rule do?

Also please post the debug log of the import. To get the debug log check How to collect debug information? document.

Hello Tharuna,

I think I am lost now, I have added everything as you said but its not working.

Would you be so kind to check my export and import fields attached ?

Thank you,
Daniel

Hello Daniel,
The field basepricewithtax is only supported in export and not in import. In import you can have product_tax or product_tax_id for rules and price_with_tax fields, RO CSVI will automatically calculate product_price based on these fields.

Hi Tharuna,

I have added field basepricewithtax to my export file but nothing have changed.

I have now 3 price fields in export with rules: product_price, product_override_price and basepricewithtax.

In import I have 2 fields with no rules: product_price, product_override_price.

Any idea what I am doing wrong ?

Thanks
Daniel

Hello Daniel,
You need to use field basepricewithtax in your export to get Final price. Let me know if that is what you are looking for.

Hello,

thank you very much for link to documentation, you have been very helpful.

I have managed to sort out mostly everything, just one / hopefully the last item I am struggling, as per attached photo I am looking for field (export/import) for FINAL PRICE. I have applied the rules to Cost price and Override and its working fine, just Final price is always the same amount...

Can you please advice ?

Kind regards,
Daniel

Hello,

Did you see the documentation on Product Status fields?

The other field you are asking for is product_discount or if needed you can use product_discount_id.

Hello one more time,

I am trying to set up correct fields for Minimum order quantity, Purchase Quantity Steps and Maximum Purchase Quantity. I have created fields for export/import as per attached picture but numbers are not correct. Please advise if these are the correct fields.

Thank you,
Daniel