- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2022 01:31 PM
I have a base for my wife’s resale business. She sells items on Ebay, Mercari, Poshmark, Facebook Marketplace, Depop, and Shopify. I am looking for a way to upload the listing reports from each platform and to compare it against the current inventory table in my base.
I have imported the active listings for each platforms into a separate table in my current base. Trying to find a way to find listings that may not have been ended when an item sells on a different platform. Any thoughts would be appreciated.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 05, 2022 12:20 AM
Hm, I assume each item has its own unique ID of some sort that stays the same regardless of the platform?
If so, I would have a table called Inventory
or something that links to each of those separate tables you mentioned, and use that unique ID to link everything together
From there, you could then use lookups and such to do the comparisons in the Inventory
table