Inventory Adjustment Log Table

The inventory adjustment log displays a chronological list of any actions that involve inventory movements within your shop. This includes moving inventory from Back of House to Front of House, destroying inventory, adjusting inventory, selling or returning inventory, and more.

Unique Composite Key(s): id, storeid

Datetime Dataset Last Updated: last_retrieved_timestamp

Incremental Load Logic: Use the column adjustment_datetime as data appends per new inventory adjustment action

Pull Previous Day - Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(adjustment_datetime) = date(date_add(now(), INTERVAL -1 day)) "}

Pull Previous Successful Update: Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(adjustment_datetime) >= $stored_last_update_datetime"}
  • stored_last_update_datetime is your stored datetime for last successful data pull

TIP: As a best practice, we recommend that you save the timestamp for each of your dataset pulls as 'stored_last_update_datetime'. Note that this value is not saved in our datasets, but is a suggestion.

Column Name

Definition

Example Output

adjustment_datetime

Date–Time that inventory adjustment was made

2020-07-21T20:07:10

product_brand

Brand Name of product

CHOICE

product_name

Product Name

LEMON SWIRL

product_type

Product Category

FLOWER

product_subtype

Product Sub Category

PRE-PACK

product_id

ID of product

f0880425-b44f-4131-9b9d-49f0efea4e6a

package_id

ID of inventory batch

8f2ea4a4-087f-4cfd-b6fd-7ee3c82095b8

state_tracking_id

Visible ID of state traceability

1A405010000A475000000005

batch_id

Visible ID of internal inventory batch

47GRO

action

Action of adjustment

MOVE

reason

Optional - reason of inventory adjustment

Counts Match

original_qty

Original quantity before adjustment

24

adjustment_qty

Adjusted quantity

-24

current_qty

Current quantity after adjustment

0

adjustment_post_excise_cost

Adjustment of inventory in cost, post-excise

-284.58

adjustment_pre_excise_cost

Adjustment of inventory in cost, pre-excise

-284.58

adjustment_excise_cost

Adjustment of inventory in excise tax

-85

adjustment_user

User ID of the one performing the adjustment

JOHN

location_name

Inventory location name at time of adjustment

FRONT OF HOUSE

inventory_id

ID of inventory batch, can be used to join to inventory table

b47abc95-1aa9-4b0b-93dd-af88be7d3791

invoice_line_id

ID of invoice line, can be used to join to invoice table

2a3209a6-adfc-4cad-bd5b-9adf00868610

credit_note_id

ID of credit note, if applicable

0b0ca1da-7e95-4345-befe-374da7eedd0c

id

Unique ID of row

b47abc95-1aa9-4b0b-93dd-af88be7d3791

storeid

ID of Store

1

retail_brand

Brand Name of Product

CHOICE

last_retrieved_timestamp

the Date–Time we last retrieved data from SellTreez

2021-06-09T14:18:30


Did this page help you?