I have an ecommerce business and I’m looking to organize things using Airtable. Below is the brief of my requirements:
Sales Channels: WooCommerce, Etsy, Amazon (Walmart, Ebay and more in the future)
- Orders comes through one of the sales channels. All important data should be populated in the table
- Packing list/slip is generated for the factory so for instance if the order is 1 kit, then the packing slip will contain all components needed for the factory. (Checklist format so components can be ticked off)
- Ability for factory/user to upload pictures for each order showing what all is packed. (Pictures can be saved elsewhere if storage is an issue. Only the last 60 days’ ordered pictures would be needed.After 60 days then can be archived if storage is an issue)
- Factory user will upload tracking to the table. There should be a sync button which automatically pushes all tracking from the table to their respective sales channel.
Assign order to factory
Track shipment and report if there is no movement
Notify admin and highlight field if existing tracking number is updated with a new one
Reship/Followup (for example order delivered was damaged or missing)
Returns pirateship integration
Dashboards - captures and store data from shopping carts (pre-and-post purchase), , track ad spend and optimization, track email marketing efforts, and more.
Let me know how long this would take to set up and how much this would cost?