Product Import and Menu items

-- HikaShop version -- : 4.4.3
-- Joomla version -- : Joomla! 3.9.23
-- PHP version -- : 7.4.28

Hello.

I need to import a fair amount of products from another site to Hika.
The process works, I did a small test and the csv is imported correctly.
Since these test products don't have a menu item, they inherit the template of the listing page they belong to. Which is not what I really want.

Now, since we are talking about 100 products to import, what I need is a suggestion on how to proceed.
Should I manually create a new menu item for each product?

IF NOT:
- How can I assign a template to these pages?
- Or at least, is it possible to assign a class to the page or body? So that you have control over what is displayed on the page. Some modules on the list page are not useful on the product pages and vice versa.

IF YES:
- Is there any way to automate the process of creating menu items from products?
- If not, should I leave the metadata, on J menu item, and only fill in the meta-fields on product?

Thank you!
Davide

Hi Nicolas, in the next days I'll try your suggestion.
I'll report back if have any problem.

Thank you!
Davide

Hello Nicolas.
I was trying your second solution, to avoid the need of a new extension (Even if Regular Labs creates good products)
I have just a problem with the mass-action.
If I put your string, it doesn't change the {product.product_id}-{product.product_alias} with the correct value.
In the screenshot below you can see the result.
Of course, I've tried different solutions, like without "product.", but nothing does the job.
Where am I wrong?

And one more question: would be possible to add also the manufacturer name in the Canonical URL building process.
My actual folder tree is this:
- Seed
-- Autoflowring
--- Product
Now, as I'm adding new manufacturers, and following what you suggested, the tree will be
- Seed
-- Autoflowering
--- Manufacturer
---- Product

It would be nice to generate, via Mass-Action, a Canonical URL like
seed/autoflowering/{manufacturer_name}/{product_alias}

Thank you!
Davide

It works if I clear all the blank spaces in your string.
Thank you!

About the second question of the previous mail: adding also the manufacturer name inside the canonical URL string, do you have any suggestion?
It seems that this data is stored into another table. Is it possible to recall it with this Mass Action?

It's not a big problem, as we don't have a huge amount of brands, so I can create different Mass Actions for the specifics barnds.

Have a nice day
Davide

Hi Nicolas!
Your script worked perfectly. I've just changed category->name with category->alias as it's an URL
And, looking at it I've managed to retrive the Brand Name in my customized product cards too.
Thanks a lot!

This is solved!

Hi Nicolas.

Thank you for all your tips!
That's all, I guess.

Have a nice day.
Davide

Hello Nicolas,
the client has decided to review the whole product's organization.
The new catories tree will be
- seeds
- > autoflowering
- - > Brand
- > regular
- - > Brand
So the previous code isn't the best solution, cause a brand can be present in both auto and regular seeds categries.

After a lot of tries and research on forum I've created this mass Action

$productClass = hikashop_get('class.product');
$product = new stdClass();
$product->product_id = {product_id};
$productCategories = $productClass->getCategories($product->product_id);

$categoryClass = hikashop_get('class.category');
$canonical ='/it';
foreach ($productCategories as $productCategory) {
        $productCategory = $categoryClass->get($productCategory);
        $canonical .= '/'.$productCategory->category_alias;
}

$product->product_canonical = $canonical.'/{product_alias}';
$productClass->save($product);

A little side note.
You probably need to add this line before the foreach loop
$productCategories = array_reverse($productCategories);

This strange behaviour seems to happens only on some products; still investigating

UPDATE:
The order of the categories in the array seems to be random; or, probably, I'm missing something...

nad a little thing more:
I recive this error as I try to delete one category from the catgory list, using both Mass Action, or Action (Inside products list page)

Notice: Undefined property: stdClass::$categories in F:\siti\zoe-brand\plugins\hikashop\massaction_product\massaction_product.php on line 929

Warning: array_search() expects parameter 2 to be array, null given in F:\siti\zoe-brand\plugins\hikashop\massaction_product\massaction_product.php on line 929

Notice: Undefined variable: key in F:\siti\zoe-brand\plugins\hikashop\massaction_product\massaction_product.php on line 930