Page 1 of 1

Extend Schema.org Header Tag with SKU and ASIN per product

Posted: Wed Nov 15, 2023 8:21 pm
by Denzel
With this addon, database fields for SKU and ASIN can be added to the product. If the Product Schema JSON-LD Header Tag Module is installed and activated, this data is added to the source code.
Schema data for your local business will also be added.
You need to customize the schemaExtend.php file in templates/default/includes/hooks/shop/product_info/ according to your needs.

To add the database fields to your product table, it is necessary to execute the following SQL statement in phpMyAdmin or use the Databasetool by @zipurman:

Code: Select all

ALTER TABLE `products` ADD `products_sku` CHAR(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `products_gtin`, ADD `products_asin` CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `products_sku`;
After altering your databasetable, just upload the three files of the zip archive. No files will be overwritten.

!!! needs ht_product_schema.php from Phoenix v1.0.8.21 !!!

v1.0.0 for Phoenix v1.0.8.21
php8.x TESTED

Now uploaded to the addons section. You may get the required ht_product_schema.php from here.

Regards,
Denzel

Re: Extend Schema.org Header Tag with SKU and ASIN per product

Posted: Thu Nov 16, 2023 11:11 am
by burt
Always place hooks outside the template structure, unless it is a hook specifically for the template.