Database I/O Manager (DbIo) Plugin [Support Thread]

[lat9]

Confirmed this has corrected both issues.

Thank you Lat9!

... and thanks to you for the confirmation!

[Ryk]

Have I missed something? I've been through the docs and worked through this thread, but cannot find how to import metatag data?

What is the correct Mapping to get these old EasyPopulate fields into Zen Cart via DBIO:

v_metatags_title_1
v_metatags_keywords_1
v_metatags_description_1

I can export the existing metatags but couldn't see how to import


Thanks in advance

[lat9]

There's a built-in customized Products export that will export the current products and their metatags for review/update.

[Ryk]

Thanks for the quick reply and yes ... but that only includes the product id, model and the various metatag statuses - not the content of the title, keywords and description fields that are stored in the metatags tables. Do we need to customise further?

[lat9]

Thanks for the quick reply and yes ... but that only includes the product id, model and the various metatag statuses - not the content of the title, keywords and description fields that are stored in the metatags tables. Do we need to customise further?

What version of DbIo is in use? I'll note that versions prior to v1.6.1 had issues with the products' metatags.

If you're running v1.6.1 or later, you can simply adjust that metatags customized output to include the fields from the meta_tags_products_description table.

[Ryk]

Thanks Cindy. The client has v155....I'll recommend he upgrades.

[lat9]

Yep, DbIo's current version is v1.6.3.

[torvista]

Regarding product categories

Previously

https://www.zen-cart.com/showthread....09#post1336509

If you're asking how to create "linked products" ... you simply have a Products import that duplicates the product's definition, once for each linked category. The final record for the product will contain the category "path" to the product's master-category.

So the field

v_categories_name

is always additive?

If a product already has multiple links and I want to delete those links so only the master category remains in p2c table...?
Is there a way with an import, or I should just use sql?

I would have thought a product should have a column for the master category and another column for additional categories (containing multiple categories) which would replace any already defined...so if empty, remove those defined...?

[lat9]

Regarding product categories

Previously

https://www.zen-cart.com/showthread....09#post1336509



So the field

v_categories_name

is always additive?

If a product already has multiple links and I want to delete those links so only the master category remains in p2c table...?
Is there a way with an import, or I should just use sql?

I would have thought a product should have a column for the master category and another column for additional categories (containing multiple categories) which would replace any already defined...so if empty, remove those defined...?

@torvista, I'll revisit the products/categories options for a Products import ... as tracked via this GitHub issue: https://github.com/lat9/dbio/issues/178

[lat9]

@torvista, I'll revisit the products/categories options for a Products import ... as tracked via this GitHub issue: https://github.com/lat9/dbio/issues/178

There's an update now available for pre-release testing of v1.6.4 on the DbIo GitHub repository. That release will contain corrections for a couple of issues as well as a change to address this request.

Starting with v1.6.4, the Products import supports an UNLINK 'v_dbio_command' that works in conjunction with the 'v_categories_name' field. Just include the product's ID (or unique products_model), the categories-name 'chain' and the UNLINK command. If the product and category both exist and the category isn't the product's master_categories_id, that unlink operation will succeed.