Showing All Products in an Easy-to-Scan Listing

  • Posts: 36
  • Thank you received: 4
  • Hikashop Essential
3 weeks 3 days ago #365087

-- HikaShop version -- : 5.1.2
-- Joomla version -- : 4.4.9
-- PHP version -- : 8.2.26
-- Browser(s) name and version -- : Firefox 133.0.3
-- Error-message(debug-mod must be tuned on) -- : none

I'm working on a website with over 1,000 products. The business owner should be provided a full listing of all products in the database along with their characteristics, variants and prices. It would be an onerous task to proofread the entire catalog by visiting individual web pages; a summary listing can be perused more easily.

My attempts at a Mass Action solution have been unsuccessful. (The HikaShop Export function works well for other purposes but doesn't render the suitable output for a quick scan by a human.)

One solution suggested was the use of the HikaSerial Massaction Display & Export plugin. Unfortunately a demonstration page for the plugin doesn't exist and I haven't been able to find a comprehensive demonstration of its features.

What I am hoping for in the output are lines in a spreadsheet or PDF file that list the details of each product. An example:

product_nameCharacteristicVariantprice_value
E36 M Technic Steering WheelBlack Alcantara fabric with black stitchingWhite Alcantara$290.00
E36 M Technic Steering WheelBlack Alcantara fabric with black stitchingNo Stripe$265.00
E36 M Technic Steering WheelTwo-Tone OptionWhite Alcantara$320.00

Is it possible to construct such a report using a Mass Action?
If not, will the HikaSerial Massaction Display & Export plugin work as desired?


Charles

Please Log in or Create an account to join the conversation.

  • Posts: 83103
  • Thank you received: 13416
  • MODERATOR
3 weeks 3 days ago #365088

Hi,

I don't see a way to output something exactly like this with any tools available in or around HikaShop.
Supposing that products can have 0, 1 or several characteristics linked to them, it makes outputting a table like in your message impractical.
For example, for a variant, the "product_name" of the variant is usually empty in the database, since HikaShop actually displays the "product_name" of the main product on the frontend. And if the product of the variant has 2 characteristics attached to it ( like color and shoe size in this example: demo.hikashop.com/index.php/en/hikashop/...with-characteristics ), then you can't have just one "characteristic" column with one "variant" column.
Also, the price of a variant might not be provided in the variant. In that case, the variant will inherit from the price of the main product on the frontend. And products and variants can each have several prices for different currencies or zones or user groups.
All of this needs to be taken care of to output a clean table with relevant information. Not everything might apply to your situation, but that means that having a generic system to output exactly what you want is difficult.
The best would be to develop a small plugin to output the data the way you need it.

With the mass actions system:
You could create a mass action with an action "display the results" with the columns "product_name", "price_value", and the characteristics you want to take into account:
i.imgur.com/lZVEcxm.png
And that will output something like this once you press on the "process" button :
i.imgur.com/nC6uZjG.png
You have first the product_name column, which contains the product_name of the product or variant of the row. So this can be empty if a variant doesn't have a product_name (which is usually the case).
Then, you have the "price_value" column with the prices linked to the product / variant. This can also be empty if the variant inherits from the price of the main product.
Then, you have one column for each characteristic. So, if you have many characteristics, you will have many columns there.

The "HikaSerial Massaction Display & Export plugin" has nothing to do with what you want to do.

Please Log in or Create an account to join the conversation.

Time to create page: 0.056 seconds
Powered by Kunena Forum