Resolved hikashop products 2 prices - only see one

Hello Suzanne,

Can you please post the debug log of your export so I can see how the export runs?

Hi Roland,
please see the log.
I would like to see the 2 prices for each product.

regards

Suzanne

Hello Suzanne,

I have seen the issue and it will need a bit of work to fix but I will post a patch for you tomorrow. Just to explain, CSVI currently exports one price only, the query needs to be updated to export all prices a product is linked too. This does mean you will get duplicate products but with a different price per line.

Hello Suzanne,

Attached is the patch file you can load via the maintenance menu. After that you should get your multiple prices in the export file.

Yes, it works!

But... there is no product-price-access-level field to show the difference between the two records. I need this as well of course, otherwise I can't check if the right price is connected to the right ACL.

(I've asked hikashop where i can find this field, it's not in the table)

regards

Suzanne

Hello Suzanne,

In that case, what you are looking for is more a Price import/export which contains all the price fields. This would then in addition have the product code, so you know which product it is. I will see what I can whip up.

That is not in the table because it is linked to the Joomla usergroups, so this info is coming out of a Joomla table.

Hello Suzanne,

Attached is a price export for HikaShop. You can load the patch file via the maintenance menu. After that you also need to follow the steps outlined in the Missing Fields in CSVI. After that you should be able to create a price export template for HikaShop.

There are 2 filters, one for currency and one for access level. Let me know how it goes.

Hi,
It's almost working...

Since, it's now clear I need to combine the product en price table to get my 2 prices for each product, I removed the price field from the product export template because I no longer need it there, but no it still exports each product twice.

How do I resolve that again?

regards

Suzanne

Hello Suzanne,

Go to the Fields tab and hit Select for the Group By and select product_sku in the popup. Save the selection and template and the export should contain only one product.

For reference see the Use of Group By and Sort By fields tutorial.

Ah, never mind... found it!

Ok, it's not working...

I thought by selecting one of my two price ACL groups under Template - Options - Price Options - Access level price
this would result in *one* record per product, but actually, I get the following error:


Fout
Not unique table/alias: 'pr' SQL=SELECT `p`.`product_id`, `p`.`product_code`, `p`.`product_manufacturer_id`, `p`.`product_name`, `p`.`product_canonical`, `p`.`product_alias`, `p`.`nietverzenden`, `p`.`product_published`, `p`.`product_status`, `p`.`product_quantity_layout`, `p`.`product_access`, `p`.`product_quantity`, `p`.`product_dimension_unit`, `p`.`product_height`, `p`.`product_width`, `p`.`product_length`, `p`.`product_weight_unit`, `p`.`product_weight` FROM `gs1jf_hikashop_product` AS `p` LEFT JOIN `gs1jf_hikashop_price` AS `pr` ON `p`.`product_id` = `pr`.`price_product_id` LEFT JOIN `gs1jf_hikashop_price` AS `pr` ON `pr`.`price_product_id` = `p`.`product_id` WHERE `p`.`product_type` = 'main' AND (`pr`.`price_access` LIKE '%,12,%')

Wah, that doesn't work because we are joining the price table twice, I missed the second price table. That is only done when a price filter is used.

The attached patch, fixes that issue.