s06e06 AND s04e10 - Product Specifications QUESTIONS/SUPPORT

Open to all! Ask other shopowners for help.
braadso

Re: s04e10 - Product Specs. Tab do not show in Catagories/Products

Post by braadso »

Waiting for updates.
Until then I have two Categories/Products in the admin.
Working, but not "handy".

Tags:


Join The Code Co-op to get access to your library in the Code Co-op Forum
admin
Contributor
Posts: 217
Joined: Wed Oct 30, 2019 1:34 pm
Phoenix Version:
Has thanked: 20 times
Been thanked: 22 times

Re: s04e10 - Product Specs. Tab do not show in Catagories/Products

Post by admin »

braadso wrote: Tue Sep 07, 2021 8:52 am Until then I have two Categories/Products in the admin.
Working, but not "handy".
Update instructions here https://github.com/CE-PhoenixCart/Updat ... /README.md
indicate to delete the files:
admin/categories.php
admin/includes/boxes/catalog_categories.php
admin/includes/languages/english/categories.php
admin/includes/languages/english/modules/boxes/catalog_categories.php
includes/hooks/admin/categories/focusRequiredTab.php
braadso

Re: s04e10 - Product Specs. Tab do not show in Catagories/Products

Post by braadso »

Know this, done that and lost two modules.
Restored and may live with two Categories/Products to be able to use them.
Waiting for updates on modules.
heatherbell
Senior Contributor
Posts: 2540
Joined: Mon Oct 07, 2019 4:39 am
Phoenix Version:
Has thanked: 35 times
Been thanked: 243 times

Re: s04e10 - Product Specs. Tab do not show in Catagories/Products

Post by heatherbell »

braadso wrote: Tue Sep 07, 2021 9:20 am Waiting for updates on modules.
I cannot see any addon or integration for CKEDITOR5 published or maintained here so you will need to contact the author that created it wherever you downloaded it.
braadso wrote: Tue Sep 07, 2021 8:35 am No idea of how to create a hook.
Nobody suggested to create a hook, just move and edit what you have according to the suggestion by @Kofod95
Create a folder/directory named catalog in /includes/hooks/admin/
Open your current /includes/hooks/admin/categories/groups.php
Change Line 12 to:

Code: Select all

class hook_admin_catalog_groups {
Change Line 113 to:

Code: Select all

    require_once language::map_to_translation('hooks/admin/catalog/groups.php');
Save to /includes/hooks/admin/catalog/
If used for nothing else you could delete the obsolete /includes/hooks/admin/categories
Create a folder/directory named catalog in /includes/languages/english/hooks/admin/
Move /includes/languages/english/hooks/admin/categories/groups.php to /includes/languages/english/hooks/admin/catalog/
If used for nothing else you could delete the obsolete /includes/languages/english/hooks/admin/categories
lecarlb
Contributor
Posts: 316
Joined: Mon Oct 26, 2020 5:26 pm
Phoenix Version:
Has thanked: 48 times
Been thanked: 9 times

s04e10 - Product Specs. assign tags to products on a mass scale

Post by lecarlb »

What would be the best way to assign tags to products on a mass scale? I know I can download a db file, edit data, upload.

Any other suggestions?

Thanks.
raiwa
Certified Developer
Posts: 1640
Joined: Sat Dec 21, 2019 8:08 am
Phoenix Version: 1.1.0.6
Has thanked: 70 times
Been thanked: 152 times

Re: s04e10 - Product Specs. Tab do not show in Catagories/Products

Post by raiwa »

@zipurman ’s data wizard should do this:
https://phoenixcart.org/forum/app.php/ ... ta_wizard/
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
lecarlb
Contributor
Posts: 316
Joined: Mon Oct 26, 2020 5:26 pm
Phoenix Version:
Has thanked: 48 times
Been thanked: 9 times

Re: s04e10 - Product Specs. Tab do not show in Catagories/Products

Post by lecarlb »

raiwa wrote: Wed Oct 06, 2021 6:51 am @zipurman ’s data wizard should do this:
https://phoenixcart.org/forum/app.php/ ... ta_wizard/
I was checking to see if anyone has developed an easy system. Now I must assign sample products to tags then download a template to see how to best manipulate data.
lecarlb
Contributor
Posts: 316
Joined: Mon Oct 26, 2020 5:26 pm
Phoenix Version:
Has thanked: 48 times
Been thanked: 9 times

Re: s04e10 - Product Specs. assign tags to products on a mass scale

Post by lecarlb »

I don't see where this can be done with the DataWizard because it doesn't use the products_tags, tags_groups tables. @raiwa @zipurman
User avatar
zipurman
Builder
Posts: 540
Joined: Tue Oct 13, 2020 5:20 pm
Phoenix Version: v
Has thanked: 93 times
Been thanked: 162 times

Re: s04e10 - Product Specs. assign tags to products on a mass scale

Post by zipurman »

The tags tables are not part of the core so currently datawizard doesnt target them. I am going to add the ability to add custom tables when I get a chance.
zipurman
-----------
ecartz
Core Team
Posts: 3084
Joined: Tue Nov 05, 2019 6:02 pm
Phoenix Version:
Has thanked: 4 times
Been thanked: 208 times

Re: s04e10 - Product Specs. assign tags to products on a mass scale

Post by ecartz »

If you have a SQL query that produces the correct list of product IDs to have a particular tag and value. E.g. something like

Code: Select all

SELECT products_id FROM products_to_categories WHERE categories_id = 1
Then you can assign a tag and value to all those products with

Code: Select all

INSERT INTO products_tags SELECT products_id, 2 AS groups_id, 3 as groups_members_id FROM products_to_categories WHERE categories_id = 1
Replace 2 and 3 with the actual IDs of the right tag and value.

It perhaps should be obvious, but just to make sure we are on the same page: you have to create the tag and value before doing this. This just associates an existing tag and value with a set of products.

Also, please remember the initial "if". This only works if you can generate the list of product IDs with a SQL query.


Join The Code Co-op to get access to your library in the Code Co-op Forum
Post Reply