Data Wizard

Open to all! Ask other shopowners for help.
User avatar
zipurman
Builder
Posts: 540
Joined: Tue Oct 13, 2020 5:20 pm
Phoenix Version: v
Has thanked: 93 times
Been thanked: 162 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
-----------


Join The Code Co-op to get access to your library in the Code Co-op Forum
raiwa
Certified Developer
Posts: 1640
Joined: Sat Dec 21, 2019 8:08 am
Phoenix Version: 1.1.0.6
Has thanked: 70 times
Been thanked: 152 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
Builder
Posts: 540
Joined: Tue Oct 13, 2020 5:20 pm
Phoenix Version: v
Has thanked: 93 times
Been thanked: 162 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
-----------
lecarlb
Contributor
Posts: 316
Joined: Mon Oct 26, 2020 5:26 pm
Phoenix Version:
Has thanked: 48 times
Been thanked: 9 times

Re: Data Wizard

Post by lecarlb »

Looks great!
User avatar
zipurman
Builder
Posts: 540
Joined: Tue Oct 13, 2020 5:20 pm
Phoenix Version: v
Has thanked: 93 times
Been thanked: 162 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
-----------
User avatar
Cary
Member
Posts: 34
Joined: Fri Mar 12, 2021 9:36 pm
Phoenix Version: v1.0.9.1
Has thanked: 3 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
Member
Posts: 13
Joined: Sat Sep 04, 2021 5:32 am
Phoenix Version:
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
Builder
Posts: 540
Joined: Tue Oct 13, 2020 5:20 pm
Phoenix Version: v
Has thanked: 93 times
Been thanked: 162 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
-----------
blavak

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
Member
Posts: 18
Joined: Sun Aug 29, 2021 11:21 am
Phoenix Version:
Been thanked: 2 times

Re: Data Wizard

Post by jan_hartvig »

Waiting :-)


Join The Code Co-op to get access to your library in the Code Co-op Forum
Post Reply