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

[lat9]

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

Use a v_products_id of 0 and either remove the v_products_date_added column or change the date value to be a real date.

[JimmyV]

Just wanted to say this is awesome. I have been using a custom easypopulate version for years and after updating Maria a couple days ago it had error log issue and altering the code was taking longer than 2 minutes to fix so I got annoyed and found this. Its actually better than what I had been using once you setup a custom file creation. Weird it has so few downloads given how good it is. So thank you !!!

[lat9]

Just wanted to say this is awesome. I have been using a custom easypopulate version for years and after updating Maria a couple days ago it had error log issue and altering the code was taking longer than 2 minutes to fix so I got annoyed and found this. Its actually better than what I had been using once you setup a custom file creation. Weird it has so few downloads given how good it is. So thank you !!!

Thanks for your kind words!

[JimmyV]

Certainly

Now if I wanted to bring all the special prices into the products feed to make it one huge csv I'd put that where? Looking in classes appears right. So into the ability to create a "custom" report I'd want to add
v_specials_new_products_price
v_specials_new_products_group_a_price
v_specials_new_products_group_b_price
v_specials_new_products_group_c_price
v_specials_new_products_group_d_price
to compliment the various group pricing tiers

[lat9]

In which table do the specials_new_products_group_x_price fields exist?

[JimmyV]

specials table...

its where if you have a special date designated sku it goes there on sale for x expiring on y and so forth

[lat9]

Hmm, the DbIoSpecialsHandler could be 'cloned' to handle those additional fields.

[JimmyV]

Yes working on learning how this was done/written and expanding that function.

[robertluer]

Anyone using this plugin successfully in Zencart 2.0.1 or will it need updating?

[torvista]

yes, no