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

swguy:

File Sent - Versions are ZC 1.5.8a and DbIo 2.0.2.
The CSV file you sent is missing the (required) v_products_id column, which DbIo properly complains about when trying to import.

This seems to be a 1.5.8 related issue; a stock 1.5.8 cart also downloads a Featured csv starting with products_model rather than products_id.

Unless the issue is obvious, please don't spend a bunch of time on this. I have told the client they'll have to upgrade after Christmas.

v2.1.0 of DbIo is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

This release contains changes associated with these GitHub issues:

#135: Adding LINK and MOVE commands to DbIoProductsHandler.
#216: Add REMOVE command to DbIoFeaturedHandler; export format also changed, now includes products_id.
#241: Allow MySQL-formatted dates to be accepted on import, regardless of the 'CSV: Import Date Format' setting.

P.S. The change for #216 also corrects the issue that @swguy reported above.

Wonderful - thank you!

I just installed Dbio on 2.0.1. I have exported ProductsAttribsRaw and gave it a look over. I have an Excel spreadsheet which I use to price attributes. In order to import a csv file of my price spreadsheet I am thinking I need to add "v_products_attributes_id", "v_products_model" and "v_options_values_price"...should that be all I need or will it create new duplicate entries if I don't have all the values in it to match the Dbio export exactly?

GoldBuckle:

I just installed Dbio on 2.0.1. I have exported ProductsAttribsRaw and gave it a look over. I have an Excel spreadsheet which I use to price attributes. In order to import a csv file of my price spreadsheet I am thinking I need to add "v_products_attributes_id", "v_products_model" and "v_options_values_price"...should that be all I need or will it create new duplicate entries if I don't have all the values in it to match the Dbio export exactly?
Using a v_products_attributes_id would be very problematic, that's why the handler uses v_products_id, v_options_id and v_options_values_id to locate the attributes-id.

If you haven't already, you might consult the DbIo wiki for that handler's usage notes: https://github.com/lat9/dbio/wiki/Handler%E2%80%90specific-Usage-Notes#productsattribsrawhandler

I have read through the wiki but I'm still not clear on which option in the DBIO would be best for what I am trying to accomplish. I want to update db values in the following field:

v_options_values_price

1. As a test I created a csv file with values in the v_options_values_price field that I wanted to update.

2. I added the required fields (v_products_id, v_options_id, v_options_values_id) listed in the Wiki's ProductsAttribsRawHandler along with it.

3. I got a successful upload message at the top of the DB Manager Page but none of the values updated on the products when I checked. I'm not sure what I did wrong, even looked in the tables and there were no new values created.

Eventually when I get the upload right I would also like to update these fields as well:
v_products_attributes_weight
v_attributes_price_onetime

Thanks in advance!

Best,
Goldbuckle

lat9:

Using a v_products_attributes_id would be very problematic, that's why the handler uses v_products_id, v_options_id and v_options_values_id to locate the attributes-id.

If you haven't already, you might consult the DbIo wiki for that handler's usage notes: https://github.com/lat9/dbio/wiki/Handler%E2%80%90specific-Usage-Notes#productsattribsrawhandler

GoldBuckle:

I have read through the wiki but I'm still not clear on which option in the DBIO would be best for what I am trying to accomplish. I want to update db values in the following field:

v_options_values_price

1. As a test I created a csv file with values in the v_options_values_price field that I wanted to update.

2. I added the required fields (v_products_id, v_options_id, v_options_values_id) listed in the Wiki's ProductsAttribsRawHandler along with it.

3. I got a successful upload message at the top of the DB Manager Page but none of the values updated on the products when I checked. I'm not sure what I did wrong, even looked in the tables and there were no new values created.

Eventually when I get the upload right I would also like to update these fields as well:
v_products_attributes_weight
v_attributes_price_onetime

Thanks in advance!

Best,
Goldbuckle
Are you trying to add a new attribute price or update an existing one? Perhaps if you'd post the contents of the CSV you're using, that would help as I've successfully updated an attribute's price using the method you described.

Update existing ones. Double checking my csv, will post a sample if the issue persists.

lat9:

Are you trying to add a new attribute price or update an existing one? Perhaps if you'd post the contents of the CSV you're using, that would help as I've successfully updated an attribute's price using the method you described.

v2.2.0 of the Database I/O Manager is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

This release contains changes associated with these GitHub issues:

#242: Correct PHP 8.5 deprecation on use of boolean vs. bool cast.
#245: Correct PHP warning when exporting ProductsOptionsValues.
#246: Correct PHP "strict mode" fatal error when using ProductsAttribsRaw handler.
#251: Allow 'NULL' import to nullable fields.
#254: Dropping support for zc157

• Adding support for array-based handler language files.
• Removing zen_cfg_read_only.php from the extra_functions directory; it's in-core for zc158+.
  #253: Font Awesome classes changed for FA v6, still keeping FA 4 support for zc158.
  #255: Use updated Encoding class, for PHP 8.0+ support.
  #257: Various handlers can have unencoded text fields for a latin1 export.
  #259: Provide a zen_config polyfill, supporting that change for zc300.
  #261: Added handlers for Products' Options' Stock Manager; it needs to be installed for the handlers to be used.
  #247: Adding type-hints to plugin's classes; all files in /YOUR_ADMIN/includes/classes/dbio were modified.
  #264: DbioProductsOptionsValuesHandler issuing incorrect errors for missing option-id values.

v2.2.1 of the Database I/O Manager is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

This release contains updates for these GitHub issues and should be used instead of v2.2.0:

#265: Correct language_id default to prevent PHP Fatal error if no language element in import.
#266: Correct type-hint for DbioHandler::key_index; changing to int|false.
#267: Additional modifications for missed type-hinting changes introduced in v2.2.0.

I cannot load Dbio manager from the tools menu. I have upgraded from v2.1.0 to v 2.2.1 and I am using ZC 2.2.2 and PHP 8.2
I receive the following http 500 error. Any advice please?

[23-Jun-2026 09:12:30 UTC] PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23

[23-Jun-2026 09:12:30 UTC] Request URI: /admin/index.php?cmd=dbio_manager, IP address: xx.xxx.xxx.xx
--> PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23.

[23-Jun-2026 09:12:30 UTC] Request URI: /admin/index.php?cmd=dbio_manager, IP address: xx.xxx.xxx.xx
--> PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23.

cheddars:

I cannot load Dbio manager from the tools menu. I have upgraded from v2.1.0 to v 2.2.1 and I am using ZC 2.2.2 and PHP 8.2
I receive the following http 500 error. Any advice please?

[23-Jun-2026 09:12:30 UTC] PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23

[23-Jun-2026 09:12:30 UTC] Request URI: /admin/index.php?cmd=dbio_manager, IP address: xx.xxx.xxx.xx
--> PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23.

[23-Jun-2026 09:12:30 UTC] Request URI: /admin/index.php?cmd=dbio_manager, IP address: xx.xxx.xxx.xx
--> PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23.

Yes, those last updates now require PHP 8.3 or later.

I am running PHP v 8.3. I am able to successfully export products however when importing I am getting an error page informing me that "This page isn't working right now" and that it cannot handle the request.

Additionally the log shows the following errors:

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /office/includes/classes/dbio/DbIoOptionsStockFullHandler.php(33): trigger_error()
#2 /office/includes/classes/dbio/DbIo.php(86): DbIoOptionsStockFullHandler::getHandlerInformation()
#3 /office/dbio_manager.php(44): DbIo->getAvailableHandlers()
#4 /office/index.php(16): require('/home/roastiqc/...')
--> PHP Warning: Incompatible DbIo version (2.2.1) detected. Either update the DbIo plugin to v2.2.0 or later or remove this file. in /office/includes/classes/dbio/DbIoOptionsStockFullHandler.php on line 33.

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /office/includes/classes/dbio/DbIoOptionsStockNamesHandler.php(36): trigger_error()
#2 /office/includes/classes/dbio/DbIo.php(86): DbIoOptionsStockNamesHandler::getHandlerInformation()
#3 /office/dbio_manager.php(44): DbIo->getAvailableHandlers()
#4 /office/index.php(16): require('/home/roastiqc/...')
--> PHP Warning: Incompatible DbIo version (2.2.1) detected. Either update the DbIo plugin to v2.2.0 or later or remove this file. in /office/includes/classes/dbio/DbIoOptionsStockNamesHandler.php on line 36.

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /office/includes/classes/dbio/DbIoOptionsStockUpdateHandler.php(28): trigger_error()
#2 /office/includes/classes/dbio/DbIo.php(86): DbIoOptionsStockUpdateHandler::getHandlerInformation()
#3 /office/dbio_manager.php(44): DbIo->getAvailableHandlers()
#4 /office/index.php(16): require('/home/roastiqc/...')
--> PHP Warning: Incompatible DbIo version (2.2.1) detected. Either update the DbIo plugin to v2.2.0 or later or remove this file. in /office/includes/classes/dbio/DbIoOptionsStockUpdateHandler.php on line 28.

[02-Jul-2026 05:01:33 UTC] PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /office/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /office/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /office/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey()
#1 /office/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord()
#2 /office/dbio_manager.php(239): DbIo->dbioImport()
#3 /office/index.php(16): require('/home/roastiqc/...')
#4 {main}
thrown in /office/includes/classes/dbio/DbIoProductsHandler.php on line 1331

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2
--> PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /office/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /office/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /office/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey()
#1 /office/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord()
#2 /office/dbio_manager.php(239): DbIo->dbioImport()
#3 /office/index.php(16): require('/home/roastiqc/...')
#4 {main}
thrown in /office/includes/classes/dbio/DbIoProductsHandler.php on line 1331.

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2
--> PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /office/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /office/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /office/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey()
#1 /office/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord()
#2 /office/dbio_manager.php(239): DbIo->dbioImport()
#3 /office/index.php(16): require('/home/roastiqc/...')
#4 {main}
thrown in /office/includes/classes/dbio/DbIoProductsHandler.php on line 1331.

Any suggestions?

I am getting errors when trying to import products. Here are the details from the log file if anyone happens to have a suggestion.

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /office/includes/classes/dbio/DbIoOptionsStockFullHandler.php(33): trigger_error()
#2 /office/includes/classes/dbio/DbIo.php(86): DbIoOptionsStockFullHandler::getHandlerInformation()
#3 /office/dbio_manager.php(44): DbIo->getAvailableHandlers()
#4 /office/index.php(16): require('/home/roastiqc/...')
--> PHP Warning: Incompatible DbIo version (2.2.1) detected. Either update the DbIo plugin to v2.2.0 or later or remove this file. in /office/includes/classes/dbio/DbIoOptionsStockFullHandler.php on line 33.

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /office/includes/classes/dbio/DbIoOptionsStockNamesHandler.php(36): trigger_error()
#2 /office/includes/classes/dbio/DbIo.php(86): DbIoOptionsStockNamesHandler::getHandlerInformation()
#3 /office/dbio_manager.php(44): DbIo->getAvailableHandlers()
#4 /office/index.php(16): require('/home/roastiqc/...')
--> PHP Warning: Incompatible DbIo version (2.2.1) detected. Either update the DbIo plugin to v2.2.0 or later or remove this file. in /office/includes/classes/dbio/DbIoOptionsStockNamesHandler.php on line 36.

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /office/includes/classes/dbio/DbIoOptionsStockUpdateHandler.php(28): trigger_error()
#2 /office/includes/classes/dbio/DbIo.php(86): DbIoOptionsStockUpdateHandler::getHandlerInformation()
#3 /office/dbio_manager.php(44): DbIo->getAvailableHandlers()
#4 /office/index.php(16): require('/home/roastiqc/...')
--> PHP Warning: Incompatible DbIo version (2.2.1) detected. Either update the DbIo plugin to v2.2.0 or later or remove this file. in /office/includes/classes/dbio/DbIoOptionsStockUpdateHandler.php on line 28.

[02-Jul-2026 05:01:33 UTC] PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /office/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /office/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /office/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey()
#1 /office/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord()
#2 /office/dbio_manager.php(239): DbIo->dbioImport()
#3 /office/index.php(16): require('/home/roastiqc/...')
#4 {main}
thrown in /office/includes/classes/dbio/DbIoProductsHandler.php on line 1331

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2
--> PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /office/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /office/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /office/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey()
#1 /office/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord()
#2 /office/dbio_manager.php(239): DbIo->dbioImport()
#3 /office/index.php(16): require('/home/roastiqc/...')
#4 {main}
thrown in /office/includes/classes/dbio/DbIoProductsHandler.php on line 1331.

[02-Jul-2026 05:01:33 UTC] Request URI: /office/index.php?cmd=dbio_manager&action=file, IP address: 47.213.56.2
--> PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /office/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /office/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /office/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey()
#1 /office/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord()
#2 /office/dbio_manager.php(239): DbIo->dbioImport()
#3 /office/index.php(16): require('/home/roastiqc/...')
#4 {main}
thrown in /office/includes/classes/dbio/DbIoProductsHandler.php on line 1331.

lat9:

Yes, those last updates now require PHP 8.3 or later.
I upgraded to 2.2.1 and I am using ZC 2.1.0 and PHP 8.4. No longer able to import new products, when i check the file before import, there are no errors but when i try to import, it crashes with this error

File Contents( /home/xxx/public_html/logs/myDEBUG-adm-20260715-162715-199182.log)
[15-Jul-2026 16:27:15 America/Toronto] PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /admin_xxx/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /admin_xxx/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey('products_descri...', Array, 1622)
#1 /admin_xxx/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord(Array)
#2 /admin_xxx/dbio_manager.php(239): DbIo->dbioImport('dbio.Products.L...', 'run')
#3 /admin_xxx/index.php(16): require('/home/xxx/p...')
#4 {main}
thrown in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php on line 1331

[15-Jul-2026 16:27:15 America/Toronto] Request URI: /admin_xxx/index.php?cmd=dbio_manager&action=file, IP address: 184.148.48.168
--> PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /admin_xxx/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /admin_xxx/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey('products_descri...', Array, 1622)
#1 /admin_xxx/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord(Array)
#2 /admin_xxx/dbio_manager.php(239): DbIo->dbioImport('dbio.Products.L...', 'run')
#3 /admin_xxx/index.php(16): require('/home/xxx/p...')
#4 {main}
thrown in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php on line 1331.

[15-Jul-2026 16:27:15 America/Toronto] Request URI: /admin_xxx/index.php?cmd=dbio_manager&action=file, IP address: 184.148.48.168
--> PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /admin_xxx/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /admin_xxx/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey('products_descri...', Array, 1622)
#1 /admin_xxx/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord(Array)
#2 /admin_xxx/dbio_manager.php(239): DbIo->dbioImport('dbio.Products.L...', 'run')
#3 /admin_xxx/index.php(16): require('/home/xxx/p...')
#4 {main}
thrown in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php on line 1331.

When looking at my database, of the 5 products the only product that is imported in this case is 1622 but there is no entry in the products_description table.

Thanks in advance for your help.

I upgraded to 2.2.1 and I am using ZC 2.1.0 and PHP 8.4. No longer able to import new products, when i check the file before import, there are no errors but when i try to import, it crashes with this error
This is the part that begs the question: How did you upgrade?

First, how can one upgrade to 2.2.1 and still be using 2.0.1? Hopefully a typo.

From which version, and why not 2.2.2?

Then, did you do a database only upgrade?

From the wording of your post, it looks like you may not have fully upgraded and a file or two is missing, you did not fully upgrade the database, or both.

@allmart, I've created a tracking issue on GitHub: https://github.com/lat9/dbio/issues/268

lat9:

@allmart, I've created a tracking issue on GitHub: https://github.com/lat9/dbio/issues/268
Correction now available: https://github.com/lat9/dbio/commit/0121569bb8645ea7d62ea5b9fddd03b712ef59f3

It's a simple update to line 1031 of admin/includes/classes/dbio/DbioHandler.php, adding a string cast:

                                                $record_key_value = [B](string)[/B]$db->insert_ID();