Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Cross-base table sync for an ecommerce app

Topic Labels: Base design Sync
131 1
cancel
Showing results for 
Search instead for 
Did you mean: 
visualdevs
4 - Data Explorer
4 - Data Explorer

Hey everyone! I have the following challenge in airtable:

I have 3 bases and tables:

Catalog: Products, Categories, Groups

Inventory: Products (synced with the products table from Catalog), purchase orders, purchase order items

Orders: Sales Orders, Sales Orders Items, Products (synced with the products table from Catalog)

In inventory, In the table "Products" I'm calculating the available inventory based on the Purchase Order Items quantities in a column called "Available QTY", but my issue is: how can I add a column called "Sold QTY" which sums the product quantities from the table "Sales Order Items" from the base "Orders"?

When I sync the sales order items into Inventory, the issue is that makes me sync also the Products table from Orders base. So I end up syncing 2 times the products table in the inventory base and the rollup doesn't work because each table is referencing different synced "Product" tables

1 Reply 1

Hmm, when you sync the Sales Orders Items into Inventory, what if you used an automation to link the new record to the synced 'Products' table based off of the Product data?  Then you'd be able to create that 'Sold QTY' rollup?