Resolved How to export shopper group pricing in single export

Hello Eliot,
Please post the export debug log to check. To get the debug log see How to collect debug information? document.

Hi Tharuna

See attached ...

thanks
Eliot

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.

Hi Tharuna

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

wholesale = 5
default shopper group = 2

regards
Eliot

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

Hi Tharuna

Site detail attached

regards
Eliot

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.

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

Hi Tharuna

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

regards
Eliot

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?

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

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.

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

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.