Shipt Logo

Developer

Delivery APIPlatform APIResource GuidesSFTP Connection

Transaction Log Guidelines#

Shipt has a "standard" transaction log report, which is detailed blow. If you need data in a specific format, or if you need data that is not included in the sample below, we will work with you to provide something as close to what you request as possible

Reporting Delivery#

  1. Shipt will generate your transaction log report as a CSV and deliver via SFTP
  2. Our typical delivery time is daily at 1:15 AM PDT or 12:15 AM PST. And the file will contain data for the previous 24 hours. For example, on 06/04/2024 the file would contain transactions for deliveries made on 06/03/2024. This is not the order date.
  3. We typically deliver these reports daily; however, we can deliver at any cadence you specify - including at specified delivery times

Standard Transaction Log Schema#

Field NameDescriptionsFormat
order_idUnique identifier for individual ordersType: text <br> Example: 1234
store_numberThe store number unique to each locationType: text <br> Example: 189
product_nameName of the itemType: text <br>Example: Berry Blend Trail Mix
brand_nameBrand name of the item If an item is special request then it will not have a brand nameType: text <br> Example: Simple Truth
skuThe retailer’s provided internal “sku” number. Often the internal identifier for a retailer’s productsType: text <br> Example: 1111
upcUnique identifier for an item purchased. which is not unique to a retail location This field is a shipt_upc which is like a standardized upcType: text <br> Example: 630509628124
metroName of the MetroType: text <br> Example: Birmingham
delivery_dateDate on which the order was deliveredType: text <br> Example: 2018-10-07
fulfilled_product_typeFulfilled item was a regular product or special request If it is special request then it will not have a product nameType: text <br> Example: regular_product
requested_unitsNumber of units(quantity) of an item requested by customerType: numeric <br> Example:2
requested_item_not_found_flagBinary flag for a requested item found or notType: Boolean <br> Examples: 0,1
inf_substituted_unitsIf the requested item wasn’t found and it was substituted then how much was substituted Inf: Item not foundType: numeric <br> Examples: 0,1,2
inf_non_substituted_unitsIf the requested item wasn’t found then how much was requested and not fulfilled Inf: Item not foundType: numeric <br> Examples: 0,1,2
fulfilled_unitsHow much of requested units were fulfilledType: numeric <br> Examples: 0,1,2
gmvGross merchandise value sold for an item. It is calculated by multiplying the unit price by the number of units deliveredType: numeric <br> Example: 7.19
is_alcoholBinary flag indicating if the product contains alcohol & requires an ID scan.Type: boolean <br> Example: True

Example of Standard Transaction Log#

order_idstore_numberproduct_namebrand_nameskuupcmetrodelivery_datefulfilled_product_typerequested_unitsrequested_item_not_found_flaginf_substituted_unitsinf_non_substituted_unitsfulfilled_unitsgmvis_alcohol
3120243722100116Red Gold Tomatoes Whole PeeledRed Gold47158510007294011228San Francisco2024-09-01 12:57:51.613235000regular_product1FALSE12.69FALSE
3120243722100116Simple Truth Organic Unfiltered Extra Virgin Olive OilSimple Truth82418020001111008219San Francisco2024-09-01 12:57:51.613235000regular_product1FALSE18.39FALSE
312032955014004412 Pack French Bread Pepperoni Pizzas 2 Ea246290280001111012782San Francisco2024-09-01 12:25:41.544736000regular_product1FALSE14.29FALSE
31203295501400441Bakery Fresh Half Lemon Pudding CakeBakery Fresh252875770001111063425San Francisco2024-09-01 12:25:41.544736000regular_product1FALSE16.09FALSE
31203295501400441Freshpet Fresh From the Kitchen Chicken Recipe Healthy & Natural Dog FoodFreshpet27739850062797501110San Francisco2024-09-01 12:25:41.544736000regular_product2FALSE228.78FALSE
31203295501400441Red Baron Classic Crust Supreme Pizza 23.45 ozRed Baron27790000007218063471San Francisco2024-09-01 12:25:41.544736000regular_product1FALSE14.79FALSE
31203295501400441Coffee mate Peppermint Mocha Flavored Liquid Coffee CreamerCoffee mate27808470005000088610San Francisco2024-09-01 12:25:41.544736000regular_product2FALSE211.58FALSE
31203295501400441Coffee mate Pumpkin Spice Coffee Creamer - 1qtCoffee mate27903940005000088600San Francisco2024-09-01 12:25:41.544736000regular_product3FALSE317.37FALSE
31203295501400441Carbmaster Banana Cream Pie Cultured Dairy Blend27915950001111050637San Francisco2024-09-01 12:25:41.544736000regular_product1FALSE10.99FALSE
31203295501400441Carbmaster Cultured Dairy Blend Peach27977980001111050646San Francisco2024-09-01 12:25:41.544736000regular_product1FALSE10.99FALSE
31203295501400441Carbmaster Cultured Dairy Blend Blackberry28002610001111050638San Francisco2024-09-01 12:25:41.544736000regular_product1FALSE10.99FALSE
31203295501400441Carbmaster Cultured Dairy Blend Raspberry28006500001111050647Atlanta2024-09-01 12:25:41.544736000regular_product1FALSE10.99FALSE
31203295501400441Diced Ham28376220001111097035Atlanta2024-09-01 12:25:41.544736000regular_product1FALSE13.99FALSE
31203295501400441Randall Deluxe Pinto BeansRandall28391810007009500020Atlanta2024-09-01 12:25:41.544736000regular_product1FALSE15.99FALSE
31203295501400441Marie Callender's Chocolate Satin Pie 25.6 ozMarie Callender's46033300061278110119Atlanta2024-09-01 12:25:41.544736000regular_product1FALSE18.39FALSE
31203295501400441Carbmaster Orange Vanilla Lowfat Yogurt88792640001111008745Atlanta2024-09-01 12:25:41.544736000regular_product1FALSE10.99FALSE
31206267601400902Temptations Puree with Chicken Squeezable Lickable Cat Treats - 1.7ozTemptations100529790002310013742Atlanta2024-09-01 15:32:07.705991000regular_product2FALSE26.58FALSE
31206267601400902Tart Apples & Caramel Snack Tray Pack105771370001111022310Atlanta2024-09-01 15:32:07.705991000regular_product1FALSE17.79FALSE
31206267601400902Fresh flowers230247790070559901641Atlanta2024-09-01 15:32:07.705991000special_request1FALSE16.39FALSE
31206267601400902Roll of paper towels234644550001376402839Atlanta2024-09-01 15:32:07.705991000special_request1FALSE17.19FALSE
31206267601400902Garlic bread from the bakery234645460070559901628Atlanta2024-09-01 15:32:07.705991000special_request1FALSE16.39FALSE
312062676014009021 gallon of vanilla ice cream241965900002310013743Atlanta2024-09-01 15:32:07.705991000special_request1FALSE13.29FALSE
31206267601400902Leafy Romaine Salad27589320001111091046Atlanta2024-09-01 15:32:07.705991000regular_product1FALSE13.99FALSE
31206267601400902Pepperidge Farm Farmhouse Sourdough BreadPepperidge Farm27747330001410007467Atlanta2024-09-01 15:32:07.705991000regular_product1FALSE15.99FALSE
31206267601400902Coffee mate French Vanilla Liquid Coffee CreamerCoffee mate27793550005000035022Brooklyn2024-09-01 15:32:07.705991000regular_product1FALSE18.99FALSE
31206267601400902Smart Ones Three Cheese Ziti Marinara Frozen Meal, 9 oz BoxSmart Ones27802240002580002376Brooklyn2024-09-01 15:32:07.705991000regular_product2FALSE25.98FALSE
31206267601400902Ocean Spray 64oz Cranberry GrapeOcean Spray27803680003120022007Brooklyn2024-09-01 15:32:07.705991000regular_product1FALSE14.19FALSE
31206267601400902Lean Cuisine Frozen Meal Chicken Fettuccine, Comfort Cravings Microwave Meal, Chicken Pasta Dinner, Frozen Dinner for OneLean Cuisine27809430001380018803Brooklyn2024-09-01 15:32:07.705991000regular_product3FALSE312.57FALSE
31206267601400902Lean Cuisine Frozen Meal Fettuccine Alfredo, Comfort Cravings Microwave Meal, Pasta Dinner, Frozen Dinner for OneLean Cuisine27868660001380016651Brooklyn2024-09-01 15:32:07.705991000regular_product2FALSE28.38FALSE
31206267601400902Land O'Lakes Butter With Olive OilLand O'Lakes27892190003450015179Brooklyn2024-09-01 15:32:07.705991000regular_product1FALSE13.39FALSE
31206267601400902Land O'Lakes Unsalted Sweet ButterLand O'Lakes27892770003450015192Brooklyn2024-09-01 15:32:07.705991000regular_product1FALSE17.79FALSE
31206267601400902Land O'Lakes Yellow American CheeseLand O'Lakes28242780021634190000Brooklyn2024-09-01 15:32:07.705991000regular_product1TRUE0.50.50.57.77FALSE
31206267601400902Bagel Bites Three Cheese Mini Pizza Bagel Frozen Snacks, 24 ct BoxBagel Bites28297690007008504692Brooklyn2024-09-01 15:32:07.705991000regular_product1FALSE18.99FALSE
31206267601400902El Monterey Extra Crunchy Southwest Chicken Taquitos 18 ct, 20.7 oz (Frozen)El Monterey28301070007100772211Brooklyn2024-09-01 15:32:07.705991000regular_product1FALSE110.79FALSE
31206267601400902Mozzarella Twisted Bread Sticks28319410001111090551Brooklyn2024-09-01 15:32:07.705991000regular_product1FALSE13.29FALSE
31206267601400902Sargento Balanced Breaks Cheese & Crackers, Monterey Jack & Mild Cheddar Natural Cheeses and WHEAT THINS Mini Original Snacks Snack Kit, 3-PackSargento93113400004610035341Brooklyn2024-09-01 15:32:07.705991000regular_product3FALSE314.37FALSE
31215480400522On The Border Cafe Style Tortilla ChipsOn The Border100541520078113871011Brooklyn2024-09-01 00:24:29.702417000regular_product1FALSE14.79FALSE