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

[lat9]

17,000+ line items waiting patiently to be added

Try changing line 205 of /admin/includes/classes/dbio/DbIoOptionsStockFullHandler.php from

        if ($sql_query !== false && $this->operation !== 'check') { 

to

        if ($this->operation !== 'check') { 

Does that correct the issue?

[dbltoe]

Unfortunately, not.

Got this

[lat9]

@dbltoe, shoot a copy of the to-be-imported CSV to my direct email address, please.

[dbltoe]

On the way.

[lat9]

On the way.

Thanks, dealt with via private email conversation.

[mcqueeneycoins]

Hi all, just a couple of questions I'm having trouble finding the answer to in the readme docs, etc.

1) Is there a way to update a product with a linked category without changing the master category? In otherwords, how can I add/update a new product with 2 or 3 different categories through DBIO? Can more than one category be listed in the v_categories_name column, and if so, what should I use to separate them?

2) If I turn on the "allow duplicate model" option, would I be able to simply "overwrite" an existing product with a new product without having to use the REMOVE command for the old and a new line for the NEW? I have a lot of unique, single quantity items, so trying to find an easy way to just replace old, out of stock items with the new ones without having to create a bunch of new products.

[DannyVarley]

I would like the ability to see the next product ID in the admin, I regularly create new products via the DBio plugin and to get the next product ID I have to create a test product to see the next ID and then delete the test product.

Am I missing exactly where I can see the next ID to use for new products, or if possible is there a way to add into the csv to simply use next id availible?

[lat9]

I would like the ability to see the next product ID in the admin, I regularly create new products via the DBio plugin and to get the next product ID I have to create a test product to see the next ID and then delete the test product.

Am I missing exactly where I can see the next ID to use for new products, or if possible is there a way to add into the csv to simply use next id availible?

You don't have to see the next product ID. If you simply use a v_dbio_command column and set that column to ADD, the processing will automatically add the product so long as its configuration is ok-fine.

See this (https://github.com/lat9/dbio/wiki/Pr...er-Usage-Notes) GitHub Wiki article for additional information.

[DannyVarley]

You don't have to see the next product ID. If you simply use a v_dbio_command column and set that column to ADD, the processing will automatically add the product so long as its configuration is ok-fine.

See this (https://github.com/lat9/dbio/wiki/Pr...er-Usage-Notes) GitHub Wiki article for additional information.

Perfect, this is so much simpler!

[DannyVarley]

When I try the ADD in the command I get the issues:

✗ products.products_id, line #2: Value () is not an integer
✗ products.products_date_added, line #2: Value (0000-00-00 00:00:00) is not a recognized date value; the default value for the field will be used.

not sure if I need to put something in the products id or I need to sort the issue with the date value?

Im missing something somewhere im sure