1. Comenaranjas
  2. RO CSVI
  3. Friday, 10 February 2017
  4.  Subscribe via email
Hi

Please see attached image to understand product setup.

Basicly is a normal product with 3 different prices per quantity.


CSVIpro VM export template of type product:

1 product_sku
2 salesprice
3 discountamount
4 basepricewithtax


On the salesprice we get the price for the first value only.

Is there a way we can export the 3 prices and the quantity range?


Regards
Accepted Answer Pending Moderation
Hello,
To get multiple prices for a product use Price export template instead of product template. The fields for quantity range price_quantity_start and price_quantity_end are available in price export template and not in product export template.
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
Accepted Answer Pending Moderation
Hello

Thanks I tested with price template and it works but found 2 issues.

The problem is that in price template only "product_price" is available and is the base price not the sales price.

We need to show the price with tax (salesprice) also ordering by product_sku does not seem to work.

The price template has only a few fields while the product template has a lot more + many price fields.

The "discountamount" we use is also only in the product template and missing in the price template.

Won't be easier to combine them? Isn't the price anyway something inside the product? B)

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

Isn't the price anyway something inside the product?
They are separated for a reason. If you want to import multiple prices with the product import, you would need to duplicate all the fields that you are importing. Exporting this, users will tell us that they have too many duplicates ;)

Now to get back to your issue, there is indeed no way to export the prices for the different quantities at the moment. I will have a look at this and see what we can do.
Kind regards,

RolandD

=========================
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. # 3
Accepted Answer Pending Moderation
Hello,

So I have extended the price export to include some extra price fields. Can you have a look to see if it works for you?
Attachments (1)
Kind regards,

RolandD

=========================
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. # 4
Accepted Answer Pending Moderation
Hello, the added fields work fine thank you,

The problem I see is field "custom_value" only seems available in product export template.

After testing the price export I remembered why we use product export instead and is cause there are custom field values that we export related to the products.

Price export is missing "Custom field title" in the parameters of the template so maybe is easier for you simply adding price_quantity_start and price_quantity_end to the product export template?

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,

The field custom_value is special for import/export custom fields. You didn't mention this before, yes this field is not related to prices but just to products.

Price export is missing "Custom field title" in the parameters of the template so maybe is easier for you simply adding price_quantity_start and price_quantity_end to the product export template?
This I need to think about if I want to do that because it will cause more support requests about why people have duplicates in their export file.
Kind regards,

RolandD

=========================
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. # 6
Accepted Answer Pending Moderation
Yes sorry I forgot cause we actually combine 2 fields in one, the "SKU" and the "product_attribute" naming all that product and then the "custom_value" so yes is a product export but with price fields.

In the worst case I can always create a second template just for the price of products with multiple prices but you still won't be able to export the named fields.

So I guess is a sneaky one we have here.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,

In the next release you will have the price_quantity_start and price_quantity_end field available in the product export as well. This way you can run a single product export for products with multiple prices.
Kind regards,

RolandD

=========================
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. # 8
Accepted Answer Pending Moderation
Thats great news thanks
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


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