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

Quote:

---

Originally Posted by lat9

One of those was a good guess!:D

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!

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?

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.

Quote:

---

Originally Posted by 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.

---

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).

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

Quote:

---

Originally Posted by 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.
.

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

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

Code:

---

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

---

From the debug log:

Code:

---

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.

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

Quote:

---

Originally Posted by lat9

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

---

Yes, I set it to "yes"