Resolved Virtuemart export of products from one manufacturer

Hello Daniel,
In your VirtueMart Configuration page, do you have multiple languages set under Multi language shop field? RO CSVI takes the first language as default one and looks for manufacturers from that language table. Since the Manufacturer filter is empty i assume there are no manufacturers set for your VirtueMart default language. You need to change the language which has manufacturers as the first and default language in VirtueMart configuration page or add manufacturers to your default language.

Hello Tharuna,

thank you for your advice, I will get this sorted ... one more question, is it possible to select somehow only certain products ?

Kind regards,
Daniel

Hello Daniel,

is it possible to select somehow only certain products ?

There is no product list selector, you can enter the SKUs of the products you want to include or exclude in the Product SKU option. That is the big input field you can also see in your screenshot.

Let us know if that helps.

Hello RolandD,

thank you for advice.

I am trying to figure out how to add 2 fields (On feature and Apply generic rules) which I cant find under Fields... - see attached printscreen..Any idea ?

Kind regards,
Daniel

Hello Daniel,
For On feature field use product_special field and for Apply generic rules use product_tax_id as export fields. If you don't see these fields try Updating available fields. Let me know if that helps.

Hello Tharuna,

thank you for advice, on feature is working fine, product_tax_id is just above what I meant - see attached printcreen....

I have updated available fields as well.

Kind regards,
Daniel

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

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,

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 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.

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,
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.

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,
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.

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,
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,

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,

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.

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,
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.