About the Course

Get Both Kinds of Sales Order Records

iconfinder_hamburger-menu_4600816.png

There's two different ways to store Wix Sales Data in Order Data Collections -

  • One Record for Every Order #

  • One Record for Every Item in an Order 

Both are shown and explained in the Course.

g5064.png

One Record for Every Order

Order_image2.png

Each Record contains Sales Data for one Order #.

In this organization you can search and datamine the info for any Order by referencing the unique Order #.

g5124.png

One Record for Every Item in Every Order

AllSamer4_Course_movier55 (Time 0_04_40;

Each Record represents Sales Data for one Item in every Sales Order.

For an Order with four Items, there's four Records with the same Order # but with Item info about one Item in the Order.

This type of organization can be datamined and sorted by Item Fields, like searching for how many Items of a particular SKU were sold in a time period or in a region of the world.