Categories
View Replies (2)

Resolved Product updates (pricing and information)

  1. figee
    figee
  2. RO CSVI
  3. Thursday, 30 March 2017
  4.  Subscribe via email
Hi there,

I'm using:
Joomla! 3.6.5
CSVI Pro 7.0.2

I have an external software that stores all information about the products, including pricing. I have a couple questions about how to synchronize VM using CSVI imports for this case. I'm struggling to understand why there are multiple types of product import templates (operation types Price, Product) and if I need to use both templates in order to update a single product.

Let's say I want to update the price and information for a product (for a SKU that already exists in VM).

1) Would I need to use both a Price Import AND a Product import?

2) According to this:
https://csvimproved.com/support/import/203-virtuemart/912-import-virtuemart-prices

Changing the price for a product requires the old price... without knowing the previous price, (or using "0" for the product_price) will it still overwrite the old price with product_price_new?

3) Is there a way to distinguish between the fields that one can import versus those which are exportable? The 'Available Fields' list does not seem to distinguish between these two cases.

For example, when I export price information, I have available fields such as 'basepricewithtax' and 'pricebeforetax'. However, when I import, the equivalent seems to be 'product_price'. 'pricebeforetax' is not a recognized import field.

Thanks,
Nathan
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Nathan,
1) Would I need to use both a Price Import AND a Product import?

Yes, you may need to use two imports depending on what you are trying to update. Product import would import do the basic import of product price field and product details but to update multiple prices for a product you need to do it with price import.

2) According to this:
http://csvimproved.com/support/import/203-virtuemart/912-import-virtuemart-prices

Changing the price for a product requires the old price... without knowing the previous price, (or using "0" for the product_price) will it still overwrite the old price with product_price_new?

VirtueMart products have multiple prices so we have few required fields to check the matching record and update it. One of such field is product_price and product_price_new. You should be knowing the previous price to update, using 0 or empty old price value will make CSVI think it is a new price as it couldn't find the matching record and will make a new price entry in database.

3) Is there a way to distinguish between the fields that one can import versus those which are exportable? The 'Available Fields' list does not seem to distinguish between these two cases.

First thing i wanted to say is product prices are not calculated by CSVI. VirtueMart calculates the price for CSVI. The fields in export 'basepricewithtax' are not stored in database but VirtueMart calculates it on the fly. CSVI is supporting exporting of these fields. Whereas in import 'product_price' is a field in database table. CSVI can directly import these values by reading the field name from import file. To know the fields available for import and export have a look at VirtueMart price document and on fields tab.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
figee
figee
Accepted Answer Pending Moderation
Thank you Taruna,

That's all clear to me!

~nathan
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!