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

[badarac]

One of those was a good guess!

To insert a product via import, you'll need to have both the v_products_id and v_products_model fields present in the to-be-imported CSV. Set the products_id value to 0 (not blank) and the products_model to the new product's unique model number.

And the guess I didn't make. ;-)

Works perfectly when you do that!

[badarac]

Just a quick question before I go much deeper. Is there an option to add/update categories or deos the category structure need to be in place before the file is imported?

[lat9]

There's no separate handler for categories at this time. When you import a product, the category structure will be created if it doesn't already exist.

[badarac]

There's no separate handler for categories at this time. When you import a product, the category structure will be created if it doesn't already exist.

That doesn't seem to be working. I tried adding a new product to a category that didn't exist and it gave an error.
[*] Product not inserted at line number 2, no match found for categories_name (Rich).

[lat9]

Hmm, I'll need to investigate further ...

[lat9]

Hmm, I'll need to investigate further ...

... v1.3.0-beta1 is available for download from the DbIo's GitHub repository. This version (to be released as v1.3.0) contains the changes necessary for the automatic generation of products' categories on a Products import.

Note that there's a new configuration value available: Configuration->Database I/O Manager Settings->Products: Auto-Create Categories?. The setting defaults to No; set the value to Yes for the auto-generation.
.

[badarac]

Installing it now. I'll let you know if I find any issues. Thanks!!

[badarac]

Still getting the error. I downloaded, copied the admin files, and set the config setting. Same message:

Product not inserted at line number 2, no match found for categories_name (Rich).

From the debug log:

2017-04-21 09:34:49: importProcessField (--special--, categories_name, 0, Media^Aqueous^Inkjet Paper^Innova Paper^Rich)
2017-04-21 09:34:49: Products::importAddField (--special--, categories_name, Media^Aqueous^Inkjet Paper^Innova Paper^Rich)
2017-04-21 09:34:49:[*] Product not inserted at line number 2, no match found for categories_name (Rich).

I can email you the full debug log if you PM me with your email. Anything I can do just let me know.

[lat9]

Did you change that new configuration setting? It defaults to "No" (i.e. categories not auto-created).

[badarac]

Did you change that new configuration setting? It defaults to "No" (i.e. categories not auto-created).

Yes, I set it to "yes"