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

[wmorris]

I just installed this addon to 2.1.0

I don't get this. When I click on "Manage Option's Stock" I did everything no products to show. What am I missing here?

[dbltoe]

I just installed this addon to 2.1.0

I don't get this. When I click on "Manage Option's Stock" I did everything no products to show. What am I missing here?

You're confusing Products' Options' Stock Manager (POSM) with DBIO. Instructional info for DBIO can be found at https://htmlpreview.github.io/?https...io/readme.html

[wmorris]

You're confusing Products' Options' Stock Manager (POSM) with DBIO. Instructional info for DBIO can be found at https://htmlpreview.github.io/?https...io/readme.html

I have read everything on there and I don't see anything about POSM? Then this addon will not work for me.

[dbltoe]

Manage Option's Stock is an operation of POSM, not DBIO. The wiki for POSM can be folujnd at https://github.com/lat9/options_stock_support/wiki.

[lat9]

I just installed this addon to 2.1.0

I don't get this. When I click on "Manage Option's Stock" I did everything no products to show. What am I missing here?

Like others have mentioned in this thread, the tool you're referencing has to do with Products' Options' Stock Manager (POSM), not DbIo. That said, POSM manages the stock of products' options ... do any of your products have attributes?

P.S. This discussion should be moved to its own thread.

[chuckrey]

Using ZC 2.1.0 w/ php 8.3. Responsive Classic

I am new to using DBIO plugin and all has been working very well, until I ran into an issue when importing Attributes Basic. I imported Names and Values without an issue, but when attempting to import attribute basic I receive an error which states: "Attributes not inserted at line number 2; one or more option-values (option value name) were either not present in the default language or are not associated with the products_options_id of 7."

Has anyone ran into this issue? Thanks!

[lat9]

Using ZC 2.1.0 w/ php 8.3. Responsive Classic

I am new to using DBIO plugin and all has been working very well, until I ran into an issue when importing Attributes Basic. I imported Names and Values without an issue, but when attempting to import attribute basic I receive an error which states: "Attributes not inserted at line number 2; one or more option-values (option value name) were either not present in the default language or are not associated with the products_options_id of 7."

Has anyone ran into this issue? Thanks!

For an attribute to be imported, each option-value needs to be created via either separate DbIo import or the admin's Catalog / Options Names Manager. The message you're receiving indicates that the option value doesn't exist or that the option-name its 'associated with' doesn't have an options_id of 7 (which is what's specified in the DbIo input record).

[chuckrey]

Okay, I see. I just had a look and it appears as though options id 7 is not associated with any option values whereas option id 0 is associated with all the values I need, so I just need to go about the best way to move em over. If I have any trouble, I may be back... Thank you.

[chuckrey]

For an attribute to be imported, each option-value needs to be created via either separate DbIo import or the admin's Catalog / Options Names Manager. The message you're receiving indicates that the option value doesn't exist or that the option-name its 'associated with' doesn't have an options_id of 7 (which is what's specified in the DbIo input record).

So I believe I understand the issue, I am not sure how to resolve it.

I took a smaller sample of the basic attributes values and attempted to import, but received a similar response as follows:

✗ Attributes not inserted at line number 2; no match for option name::option_type::default_language_id (Bedroom::0::1).
✗ Attributes not inserted at line number 3; no match for option name::option_type::default_language_id (Bedroom::0::1).
✗ Attributes not inserted at line number 4; no match for option name::option_type::default_language_id (Bedroom::0::1).

The import of product options and product options values processed without an issue, however the basic attributes is still giving me trouble. I am also including a screenshot of the option values with names for reference. Any suggestion to resolve? Thanks again.

[lat9]

How about posting the 3 lines from the CSV input that resulted in the error messages indicated above?