Data Wizard

Ask the community for help and support.
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Has thanked: 84 times
Been thanked: 147 times

Data Wizard

Post 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
You do not have the required permissions to view the files attached to this post.
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
raiwa
PhoenixCart Developer
PhoenixCart Developer
Posts: 1184
Joined: Sat Dec 21, 2019 8:08 am
Has thanked: 38 times
Been thanked: 102 times

Re: Data Wizard

Post 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
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing

Need Help?viewtopic.php?f=10&t=27
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Has thanked: 84 times
Been thanked: 147 times

Re: Data Wizard

Post 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 😉
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
lecarlb
VIP Member
VIP Member
Posts: 304
Joined: Mon Oct 26, 2020 5:26 pm
Has thanked: 42 times
Been thanked: 9 times

Re: Data Wizard

Post by lecarlb »

Looks great!
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Has thanked: 84 times
Been thanked: 147 times

Re: Data Wizard

Post 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.
You do not have the required permissions to view the files attached to this post.
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
User avatar
Cary
VIP Member
VIP Member
Posts: 20
Joined: Fri Mar 12, 2021 9:36 pm
Has thanked: 2 times
Been thanked: 3 times

Re: Data Wizard

Post by Cary »

Yeah, but can it Julienne fries?
Excited to see the final product!
- Cary
PandV
VIP Member
VIP Member
Posts: 13
Joined: Sat Sep 04, 2021 5:32 am
Has thanked: 5 times
Been thanked: 1 time

Re: Data Wizard

Post 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.
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Has thanked: 84 times
Been thanked: 147 times

Re: Data Wizard

Post 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 ;)
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
blavak
Posts: 3
Joined: Mon Mar 15, 2021 7:43 am
Been thanked: 2 times

Re: Data Wizard

Post 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...
jan_hartvig
Posts: 12
Joined: Sun Aug 29, 2021 11:21 am
Been thanked: 2 times

Re: Data Wizard

Post by jan_hartvig »

Waiting :-)
Post Reply