Page 1 of 2
Data Wizard
Posted: Tue Aug 24, 2021 9:10 am
by zipurman
I am still working on my version of an Easy Populate tool. Built from scratch. It would be great to hear what people use this tool for, so I can hopefully make sure it meets those needs. It will be a paid app, but it will also be worth it
Teaser image attached.
Zip
Re: Data Wizard
Posted: Tue Aug 24, 2021 9:16 am
by raiwa
Hi Preston,
Looks already great.
It would be good to have support for products options/attributes included. Or is this already available?
And also support for some addons like QTPRo, to allow support for option/attribute stock.
Cheers
Rainer
Re: Data Wizard
Posted: Tue Aug 24, 2021 9:27 am
by zipurman
raiwa wrote: ↑Tue Aug 24, 2021 9:16 am
Looks already great.
It would be good to have support for products options/attributes included. Or is this already available?
And also support for some addons like QTPRo, to allow support for option/attribute stock.
Thanks Raiwa,
It supports many tables. Also, the columns are dynamic, so any custom columns are automatically available
Going to also add some quick tools to allow for things like:
- Mass Country add to zone
- target column with % increase/decrease
- mass add attribute to prod
- mass remove attrib to prod
etc etc
Ideas welcome
Re: Data Wizard
Posted: Wed Aug 25, 2021 2:54 am
by lecarlb
Looks great!
Re: Data Wizard
Posted: Sun Aug 29, 2021 3:44 am
by zipurman
Just a quick update. I am making good progress on the DataWizard, but I am behind due to some other projects.
Here are some of the latest screenshots. I hope to have something tested and available within the next week or two.
Re: Data Wizard
Posted: Mon Aug 30, 2021 4:35 pm
by Cary
Yeah, but can it Julienne fries?
Excited to see the final product!
Re: Data Wizard
Posted: Wed Sep 08, 2021 8:12 am
by PandV
Looking forward to this tool! Would be nice if it can also export order information - this would give a route into accounting systems and mailing/shipping systems.
Re: Data Wizard
Posted: Wed Sep 08, 2021 4:26 pm
by zipurman
PandV wrote: ↑Wed Sep 08, 2021 8:12 am
Looking forward to this tool! Would be nice if it can also export order information - this would give a route into accounting systems and mailing/shipping systems.
You can do that now using the free database tool.
app.php/addons/free_addon/database_tool
You can write a sql query like:
Code: Select all
SELECT * FROM orders o, orders_products op WHERE o.orders_id = op.orders_id AND o.date_purchased >= '01/01/2021' AND o.date_purchased >= '12/31/2021' ORDER BY o.orders_id, op.orders_products_id
Then you can click the CSV to download the results. This gives you full control to downloading data ... but you have to know SQL.
I will see about also adding something for this in the datawizard that is a bit easier to use
Re: Data Wizard
Posted: Mon Sep 27, 2021 7:47 am
by blavak
Hi Zipurman.
My customers use easy populate on daily basis. If you have thousands of products, there are many situations you benefit from such tool. Mass price changes, mass product description changes, mass adding/removing of products, availabilty, manufacturer changes, .........
As i convert 3 my customers to phoenix in next year i am looking forward to this tool...
Re: Data Wizard
Posted: Mon Sep 27, 2021 7:51 pm
by jan_hartvig
Waiting :-)
