Skip to main content

Hello. I am new to Airtable and have spent a better part of a week trying to figure this out and I'm stuck. I hope the community can help me out.

Our Airtable connected to our Shopify store via Airpower, so everything is synced in real time.

We have a Table named 'Order Line Items' that displays each Shopify order and each item (SKU) is separated in its own row within the order. What we are trying to achieve is to display the inventory number for each item.

Inventory data is stored in another table named 'Variants' and organized by SKU in one field, and the inventory quantity in another field.

Does anyone have experience with dealing in anything similar?

I'm not sure if this is relevant, but I have gone as far as being able to create a field in the Order Line Items table that links to our Variants table (that contains inventory data). However, I have to manually enter the SKU that was ordered before inventory count can display. The example below where for it to work, I have to type in the SKU number in the Linked Variant SKU field. I wish to populate that field automatically with the order's SKU but have not been able to figure out the Automation. Attached is an example of the "Order Line Items" table.


Thank you.

Looks like the primary field of the "Variants" table is the SKU, so perhaps you could try an automation that pastes SKU into the text field, which would automatically link stuff up for you

If Airpower lets you put the SKU into the linked field to Variants that'd be even easier

Hey @WL35_2 

 

It sounds like you’re close to a solution; we just need a bit of automation to link up your SKU and inventory counts. Given that your Airtable and Shopify data are syncing in real-time with Airpower, we can set up an Airtable Automation to link the SKU field in the “Order Line Items” table directly to the corresponding SKU in your “Variants” table without manual entry.

  • Create a script in Airtable’s Automations that triggers when a new record is added to “Order Line Items.” This script can automatically pull the SKU from each new order, find its match in “Variants,” and fill in the linked record field with the inventory count.
  •  This method ensures that any new Shopify order item displays inventory numbers immediately, saving you time and eliminating manual data entry.

thank you all for the quick response. I will try it out.

Hey @WL35_2 ,

This is something you can achieve with SyncBase (another Shopify app) that syncs all your data from your store to Airtable in real time (few seconds, as I know Airpower can takes minutes/hours if you've got a lot of data).

1. Inside the Orders tab you can fin the Variant ID of each Order Line Item.
2. You just need to create a "Linked to another record" column (linked to the Variants tab).
3. Then you had a lookalike column type and choose InventoryItemID.  

=> You will then get your InventoryItemID for each Order Line Item record inside the Orders tab.

I've made a screenshot for you.

If you need any help feel free to ask on this thread or via DM.

Théau

Reply


Terms & Conditions