1. eliotrayner
  2. RO CSVI
  3. Tuesday, 21 June 2022
  4.  Subscribe via email
Hi Rolandd

I want to export wholesale and detault shopper group prices in a single export.

I am using RO CSVi 8.3.0. Template component is Virtuemart and Operation is Price.

I have selected the shoppergroups i want under template edit -> Options -> Shopper Group Names.

However when I export I only get Trade Shopper Group prices.

regards
Eliot
Accepted Answer
Accepted Answer Pending Moderation
Hi Tharuna

One way is to write custom code to get prices in one row and set it as an override for export.


OK, i've done that before, so will go that way.

regards
Eliot
  1. one week ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
Hello Eliot,
Please post the export debug log to check. To get the debug log see How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Tharuna

See attached ...

thanks
Eliot
Attachments (1)
  1. one week ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Eliot,
Thank you for posting requested debug log. The query in debug log shows the product prices are exported for shopper group with two IDs 2 and 5. I guess these are the IDs of wholesale and default shopper groups. But the query also shows that you have set Group by field in export template to product_sku and shopper_group_name. Can you remove these group by fields and run the export? Check if that gets the expected records on export.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hi Tharuna

I removed the Grouping and same result. I've also included debug log again

wholesale = 5
default shopper group = 2

regards
Eliot
Attachments (1)
  1. one week ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Eliot,
The latest debug log shows that products are exported from the shopper groups as set in the template. See query below from debug log and in where condition. I am wondering on how the Trade Shopper Group prices are exported. Can you send me your site administrator login details and (S)FTP details to check? You can post these details on Site Details tab under your reply. I will run the export and the query on your site and see where export goes wrong.



SELECT `nserc_virtuemart_product_prices`.`virtuemart_product_id`,
`nserc_virtuemart_products`.`virtuemart_product_id`,
`shopper_group_name`,
`nserc_virtuemart_currencies`.`currency_code_3`,
`nserc_virtuemart_product_prices`.`virtuemart_shoppergroup_id`,
`price_quantity_start`,
`price_quantity_end`,
`product_price`
FROM `nserc_virtuemart_product_prices`
LEFT JOIN `nserc_virtuemart_products` ON `nserc_virtuemart_product_prices`.`virtuemart_product_id` = `nserc_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `nserc_virtuemart_shoppergroups` ON `nserc_virtuemart_product_prices`.`virtuemart_shoppergroup_id` = `nserc_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id`
LEFT JOIN `nserc_virtuemart_currencies` ON `nserc_virtuemart_product_prices`.`product_currency` = `nserc_virtuemart_currencies`.`virtuemart_currency_id`
LEFT JOIN `nserc_virtuemart_product_categories` ON `nserc_virtuemart_product_categories`.`virtuemart_product_id` = `nserc_virtuemart_product_prices`.`virtuemart_product_id`
WHERE `nserc_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` IN ('2','5')
ORDER BY `nserc_virtuemart_product_prices`.`virtuemart_product_id` ASC
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hi Tharuna

Site detail attached

regards
Eliot
  1. one week ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Eliot,
Thank you for posting the requested details. I had a look into your AMPHORA VirtueMart Prices Export export template and the shopper group names set in filter are Default and Trade shopper groups. See attached screenshot. The ID 5 belongs to Trade shopper group and not for wholesale. Check VirtueMart Shopper groups page screenshot attached.
Attachments (2)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hi Tharuna

Default price actually has virtuemart_shoppergroup_id of 0. Which doesn't exist in the shoppergroup table but is actually represented by 'Default Shopper Group'

How can I get round this in CSVi ?

regards
Eliot
  1. one week ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hi Tharuna

Apologies I meant Trade (not wholesale) so I still have the issue.

regards
Eliot
  1. one week ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Eliot,
Default price actually has virtuemart_shoppergroup_id of 0. Which doesn't exist in the shoppergroup table but is actually represented by 'Default Shopper Group'

How can I get round this in CSVi ?

In export template on Options tab for Shopper group filter if you remove the filters Trade and Default shopper group, save the template and run the export. That should get export of all shopper groups including the prices with virtuemart_shoppergroup_id of 0. Did you try that?


Apologies I meant Trade (not wholesale) so I still have the issue.

I am confused now. In your initial post you said that export gets Trade Shopper Group prices. Since you have set Trade in Shopper group filter you are seeing those prices. So what is the issue here?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hi Tharuna

I am confused now. In your initial post you said that export gets Trade Shopper Group prices. Since you have set Trade in Shopper group filter you are seeing those prices. So what is the issue here?


The issue is getting just default price list (virtuemart_shoppergroup_id = 0) and trade price list (virtuemart_shoppergroup_id = 5) in the export.

In export template on Options tab for Shopper group filter if you remove the filters Trade and Default shopper group, save the template and run the export. That should get export of all shopper groups including the prices with virtuemart_shoppergroup_id of 0. Did you try that?


Yes, that works.

regards
Eliot
  1. one week ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Eliot,
The issue is getting just default price list (virtuemart_shoppergroup_id = 0) and trade price list (virtuemart_shoppergroup_id = 5) in the export.

When you set Default shopper group in the shopper group filter, it would export the records with virtuemart_shoppergroup_id 2 and not 0. To get records only with virtuemart_shoppergroup_id 0 and 5 you can use RO CSVI Skip rule.

Follow these steps to apply the skip rule

1. In the Skip rule set all virtuemart_shoppergroup_id separated by comma(,) which should not be included in export. Example 2,3,4,6,7
2. Add virtuemart_shoppergroup_id as template field to export and unpublish it.
3. Apply the Skip rule on virtuemart_shoppergroup_id field.
4. Run the export.

Let me know if that helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hi Tharuna

That works fine.

Is there any way to have prices exported in a tabular way i.e. both prices in the same row for a product ?

I've attached an example.

regards
Eliot
Attachments (1)
  1. one week ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Eliot,
That works fine.

Glad to know that it works as expected.

Is there any way to have prices exported in a tabular way i.e. both prices in the same row for a product ?

That is not possible with core RO CSVI. One way is to write custom code to get prices in one row and set it as an override for export.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 14
  • Page :
  • 1


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