Daily SKU Table

Daily sku reflects sales per product per day per store

Dataset ID: 25b189dc-25cd-4081-aadf-b84486a9e2ec

Unique Composite Key(s): dateclosed, storeid, product_id

Datetime Dataset Last Updated: hr_last_updated

Load Logic: This endpoint is expected to update once a day, with the previous day's sku level updated in early afternoon (Pacific Time). Due to the size of the full replacement, we unfortunately cannot provide a more accurate estimate. A product that was never sold would not show up in this table - even if this product exists in your inventory table. This endpoint has a 3-month time frame, meaning we only store the data going back 3 months.

Column Name

Definition

Example Output

dateclosed

Date

1/24/2020

daily_product_remaining

Remaining Inventory QTY for product at the end of dateclosed

32

days_out_of_stock

Days out of stock (from last in stock to current dateclosed)

12

new_stock

n/a

storeid

Unique Store ID (store location)

230

product_id

Unique Product ID Unique Product ID

c3959cab-0582-11ea-9c46-02a831a0e4d2

productname

Product Name

LEMON SOUR DIESEL

productsubtype

Product Subtype

BUDDER

size

Product Size

1G

distributor

Distributor Name

NABIS

statetrackingid

State Tracking/Traceability ID

1A4050100001645000008250

thc_perc

THC Percentage

0.2

cbd_perc

CBD Percentage

0.1

max_dateclosed

Last Recent Date of Sales Activity (e.g., 3 days ago)

1/21/2020

productbrand

Product Brand Name

KIVA

tz_brandname

Product Brand Name (Cleansed)

KIVA

producttype

Product Type

EXTRACT

sku

Product SKU

abc312

tier

Product Tier

Top Shelf Tier

weight

Product Weight

1

unitofmeasure

Product Unit of Measure

GRAMS

region

Store Region

Bay Area

tz_productname

Product Name (cleansed)

BUDDER

shortname

Store Name

Treez Dispensary

store_state

Store State

CA

classification

Product Classification

INDICA

total_mg_cbd

Total MG CBD

1

total_mg_thc

Total MG THC

2

external_id

Product External ID (e.g., identifier referenced for other systems)

391882abc

mg_per_dose

Product MG Per Dose

1

productattributes

Product Attributes

EDIBLES,CHOCOLATE

internal_tags

Product Internal Tags

HOT,TOP HOT,TOP

minimum_visible_inventory

Minimum Inventory QTY for Menu Visibility

5

hidden_from_menu

HIDE trigger FROM ONLINE MENUS (1 for hidden, 0 for not hidden)

1

package_size

Product Packaging Size

SINGLE-UNIT

product_repeat_gross

Product sales that came from repeating customers for the same product

432.12

product_cycle_days

Average cycle days of sales that came from repeating customers for the same product

12

productline_repeat_gross

Product sales that came from repeating customers for the same product line

521.34

productline_cycle_days

Average cycle days of sales that came from repeating customers for the same productline

9.3

min_exp_date

Expiration date for the inventory batch (oldest if multiple batches exist)

12/1/2020

invoice_accept_date

Most recent invoice receiving date for this product

12/1/2020

invoice_create_date

Most recent invoice creation date for this product

12/1/2020

aging

Days between dateclosed and invoice_accept_date

1/31/1900

delivery_days

Common delivery days marked for distributor

TUE, WED, THU, FRI

lead_time

Lead time for distributor (in days)

6

last_day_of_month

Is dateclosed the last day of the month?

Y

first_day_of_month

Is dateclosed the first day of the month?

N

avg_sold

Average QTY Sold in last 14 days Average QTY Sold in last 14 days

7.5

units_remaining

Current remaining Inventory QTY (as of last dataset update)

31

brand_rank_subtype

Ranking of sales by grossreceipts and grouped by storeid, dateclosed, producttype, productsubtype

3

bclass

Supply Chain ABC grading, with A in 90% of cumulative sales (grossreceipts) and B in 70% and C in remaining. Measured by product's brand Supply Chain ABC grading, with A in 90% of cumulative sales (grossreceipts) and B in 70% and C in remaining. Measured by product's brand

A

class

Supply Chain ABC grading, with A in 90% of cumulative sales (grossreceipts) and B in 70% and C in remaining. Measured by product

B

xyz

Supply Chain XYZ grading, with X in 20% of standard deviation variability over the last 6 weeks, and Y between 20% to 40%, with Z over 40%

X

total_gross_sold

Total sales (grossreceipts) of product's producttype

3121.32

total_qty_moved

Total Qty moved (e.g., between inventory locations)

13

pairs_percent

Percent of sales that happened when qty = 2 within the same ticket

0.05

lots_percent

Percent of sales that happened when qty > 2 within the same ticket

0.1

retail_brand

Product Brand Name

KIVA

total_producttype_remaining

Total QTY remaining for all products within the product type at the end of dateclosed

2432

datetime_of_move

Timestamp of last inventory movement

1/2/20 3:32

brand_rank

Ranking of sales by grossreceipts and grouped by storeid, dateclosed, producttype and ranked by tz_brandname

3

out_of_stock

Did out of stock happen on this date (1 = yes, 0 = no)

0

total_sold

Total QTY sold of product's producttype

320

brand_repeat_gross

Product sales that came from repeating customers for the same brand

731.12

brand_cycle_days

Average cycle days of sales that came from repeating customers for the same brand

18.2

total_taxes

Total taxes

382.12

qty_sold

Total QTY sold (not accounting for returns)

23

sku_sold

Total QTY sold (accounting for returns)

22

grossreceipts

Total sales (grossreceipts)

1258.2

discounts

Total Discounts

42.21

cost_per_unit

Average Cost per Unit Sold

2.43

sku_return

Total QTY Returned

2

grossreceipts_at_line

Total sales (grossreceipts) at product line

21742

priceunit

Average Price Per Unit

15

qty_sold_at_line

Total QTY sold at product line

212

days_remaining

Current remaining inventory qty / avg_sold

21.2

days_remaining_historic

Remaining inventory at the end of dateclosed / avg_sold as of dateclosed

18.3

units_available_at_line

Inventory QTY available at product line

421

sku_count

n/a

sku_count_available_at_line

Total unique product sku at product line

31

brand_count_at_line

Total brands available at product line

21

hourly_product_remaining

Current inventory available across all inventory locations

21

sellable_hourly_product_remaining

Current inventory available in sellable inventory location

19

nonsellable_hourly_product_remaining

Current inventory available in non-sellable inventory location

2

total_qty_moved_at_line

Total Inventory units moved at product line

312

new_stock_moved_at_line

Total new inventory units received at product line

9

sku_percent

qty sold / total qty sold at producttype

0.15

product_percent_remaining

units remaining / total units remaining at producttype

0.01

post_tax_priceunit

Average Price Per Unit (post tax)

14

discounttitle

All applied discounts (delimited by | )

15% OFF VETERAN/SENIOR % | 15%

discountamount

Total discounts

21.12


Did this page help you?