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

[swguy]

Success! DBIO succeeded where EZ Populate failed!

Question: would it make sense to default v_dbio_command to ADD when v_products_id = 0?

[swguy]

Oh also a question: after I exported, I copied the last row but when I tried to import I get warnings on the date field:

2022-03-22 11:17:01:[*] products.products_date_added, line #2: Value (2022-03-22 10:44:32) is not a recognized date value; the default value for the field will be used.

Should I just remove this column from the spreadsheet to prevent trouble?
I wonder if v_products_link should also be removed?

[jeking]

I searched the ReadMe and this thread but didn't see an answer. I suspect it's there as it's not a very unique question.

How do I change the Master Category? We have linked products and want to change the Master Category.

When I export, I see the v_categories_name column has only the current Master Category. Do I type in the new Master Category and re-import?

[dbltoe]

You might find help in the docs. https://docs.zen-cart.com/user/admin...aster-category.

I'm afraid the Accessibility Widget doesn't speak shikawgo.

[jeking]

You might find help in the docs. https://docs.zen-cart.com/user/admin...aster-category.

I'm afraid the Accessibility Widget doesn't speak shikawgo.

Thank you for the help. However, I was looking for a way to do it with this plugin. There are hundreds of products that need updating so was looking to avoid one by one in the admin.

[lat9]

I searched the ReadMe and this thread but didn't see an answer. I suspect it's there as it's not a very unique question.

How do I change the Master Category? We have linked products and want to change the Master Category.

When I export, I see the v_categories_name column has only the current Master Category. Do I type in the new Master Category and re-import?

Jim, see the online documentation (https://github.com/lat9/dbio/blob/ma...uctshandler.md) regarding some of the intricacies of the Products Handler, including how to (a) change the master category or (b) unlink a product from a category.

[jeking]

Jim, see the online documentation (https://github.com/lat9/dbio/blob/ma...uctshandler.md) regarding some of the intricacies of the Products Handler, including how to (a) change the master category or (b) unlink a product from a category.

Yes, that is what I was looking for. Thank you!

Here's my confusion. One of the products in question is in two categories. I see this on the product page in the admin. When I export all products, there is only one category in the v_categories_name column in the csv, the current master category. In order to change it, do I need to enter the other category name in the v_categories_name and re-import?

[lat9]

Yes, that is what I was looking for. Thank you!

Here's my confusion. One of the products in question is in two categories. I see this on the product page in the admin. When I export all products, there is only one category in the v_categories_name column in the csv, the current master category. In order to change it, do I need to enter the other category name in the v_categories_name and re-import?

Per that documentation referenced:

If the product is being updated, then the v_categories_name (if included) identifies the product's new master_categories_id.  The product's previous master_categories_id becomes a linked category.

[jeking]

Per that documentation referenced:

If the product is being updated, then the v_categories_name (if included) identifies the product's new master_categories_id.  The product's previous master_categories_id becomes a linked category.

Thanks, I'll give that a try.

[lat9]

Version 2.0.0 of DbIo is now available from the Zen Cart plugins: https://www.zen-cart.com/downloads.php?do=file&id=2091

This release contains updates for the following GitHub issues:

#209: DbIo manager, checkboxes can't be selected via labels
#207: Product Export: debug for empty trim on metatags
#206: Remove duplicate language constants for dbio_customize tool
#205: Unable to resize select windows in Safari
#203: PHP notice/warning when there's an error or it's not "ok to proceed"
#202: Drop support for Zen Cart versions prior to zc157
#201: PHP 8.2: explicitly declaring variables
#199: Use zen_cfg_read_only for the DbIo version 'setting'
#198: PHP 8.16: PHP deprecated, auto_detect_line_endings is deprecated
#197: Add shipping cost value to DbIoOrders output