Google Sheets/Airtable Ecommerce Setup
Budget: ₹1,500 – ₹12,500 INR
Hi,
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.
Functions required:
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
Additional functions:
Leads management
Tasks management
Future:
Dashboards - captures and store data from shopping carts (pre-and-post purchase), , track ad spend and optimization, track email marketing efforts, and more.
Please answer the following screening questions:
1) How long would it take you to setup?
2) How much would it cost? (Brief is quite self-explanatory and straight forward)
3) Do you have any suggestions to make it better?
4) Describe your recent experience with similar projects & feel free to share screenshots or recordings of systems you have made in the past.
5) What are the limitations with airtable and is there anything from the project description which you won't be able to achieve?
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.
Functions required:
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
Additional functions:
Leads management
Tasks management
Future:
Dashboards - captures and store data from shopping carts (pre-and-post purchase), , track ad spend and optimization, track email marketing efforts, and more.
Please answer the following screening questions:
1) How long would it take you to setup?
2) How much would it cost? (Brief is quite self-explanatory and straight forward)
3) Do you have any suggestions to make it better?
4) Describe your recent experience with similar projects & feel free to share screenshots or recordings of systems you have made in the past.
5) What are the limitations with airtable and is there anything from the project description which you won't be able to achieve?