Airtable sync and automation
Budget: $1,500 – $3,000 USD
Hope you’re well. Please find below the details for an Airtable engagement I am presently working on.
They want to use Integromat for the automation
Starting with approximately 15-20K SKUs. Below is a high-level architecture structure of how they are envisioning potentially using Airtable in conjunction with our ERP and new website.
Open Icecat - https://icecat.co.uk/
Icecat is a worldwide unique open catalogue with product data sheets in co-operation with high tech sponsoring brands and online channel partners. Open Icecat data sheets are fully approved by the sponsoring manufacturers and are distributed for free to the online channel.
Unleashed ERP https://www.unleashedsoftware.com/
Inventory Management System
Magneto https://magento.com/
Website (E-commerce)
Airtable will be used as the central product database…
New SKUs will be created with supporting information, with fields edited/amended as is necessary. This data will be merged with data from Icecat which is then exported into Unleashed allowing for field matches and the Magento website.
The Airtable will be created by uploading a created database that will use Unleashed as its principle source before being added to other fields ( EG product categories), Please see the link of what the Airtable would look like., this needs the fields adding in yellow on the CSV Taxonomy attached.
As you can see there are 3 specific areas that Airtbale will be involved in:
Sending Data to ERP (Unleashed)
Syncing Data between Ice Cat and Airtable
Sending Data to Magneto
There are 4 core users that need to consider
General Manager
Product Coordinator
Operations Manager
Customer Service / Logistics Assistant
Ice Cat Data Structure: See attached zip
Magneto/Airtable: See attached file
Unleashed: See attached file.
Please can you send me a quote which covers:
Airtable set up
Automation set up (to the relevant APIs)
Consultancy
Documentation
Please let me know when you will be able to get me a quote across. Please can you also ask any clarifying questions you may have.
They want to use Integromat for the automation
Starting with approximately 15-20K SKUs. Below is a high-level architecture structure of how they are envisioning potentially using Airtable in conjunction with our ERP and new website.
Open Icecat - https://icecat.co.uk/
Icecat is a worldwide unique open catalogue with product data sheets in co-operation with high tech sponsoring brands and online channel partners. Open Icecat data sheets are fully approved by the sponsoring manufacturers and are distributed for free to the online channel.
Unleashed ERP https://www.unleashedsoftware.com/
Inventory Management System
Magneto https://magento.com/
Website (E-commerce)
Airtable will be used as the central product database…
New SKUs will be created with supporting information, with fields edited/amended as is necessary. This data will be merged with data from Icecat which is then exported into Unleashed allowing for field matches and the Magento website.
The Airtable will be created by uploading a created database that will use Unleashed as its principle source before being added to other fields ( EG product categories), Please see the link of what the Airtable would look like., this needs the fields adding in yellow on the CSV Taxonomy attached.
As you can see there are 3 specific areas that Airtbale will be involved in:
Sending Data to ERP (Unleashed)
Syncing Data between Ice Cat and Airtable
Sending Data to Magneto
There are 4 core users that need to consider
General Manager
Product Coordinator
Operations Manager
Customer Service / Logistics Assistant
Ice Cat Data Structure: See attached zip
Magneto/Airtable: See attached file
Unleashed: See attached file.
Please can you send me a quote which covers:
Airtable set up
Automation set up (to the relevant APIs)
Consultancy
Documentation
Please let me know when you will be able to get me a quote across. Please can you also ask any clarifying questions you may have.