Hi,
Each of my hikashop products has 2 prices each for a different ACL group.
When exporting I would expect to see 2 records per product, one for each price and the related ACL group.
How would i export both prices?
regards
Suzanne
Hello Suzanne,
Can you please post the debug log of your export so I can see how the export runs?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.