Automate Shopify, Ebay and Amazon using Excel data files

excel trainer and training courses, uk
Dr Peter Clayton
BEng MBA PhD
CMC CMgr FCMI FIC Excel Consultant efficiency automation and training

EXCEL CONSULTANT

  • I have extensive use of using Excel formulas and macros to automate the creation of stock, inventory and price data files to upload to all the major shopping marketplaces.
  • Use Excel to take your downloaded e-commerce inventory files from Amazon. Ebay or Shopify to update stock and price values before uploading them again to update them online.

“As a small business owner my time is in great demand; Peter’s work has enabled me to carry out some of my routine tasks in a fraction of the time it usually takes.” 

Charlotte Baldwin, Colour Your Garden

Automate Shopify, Ebay and Amazon using Excel data files through File Exchange, Matrixify / Excelify, Simple Inventory and other apps

  • I can help you speed up and automate the updating of e-commerce data file to be uploaded to Shopify, Ebay and Amazon eg using Matrixify / Excelify, Ebay File Exchange, “Simple Inventory” and other apps.
  • Download Matrixify/Excelify data files and use Excel formulas and macros to auto-fill the fields such as updating stock quantities, prices and title changes based on stock files from suppliers.
  • Upload the modified files back to Shopify, Ebay File Exchange and Amazon to make the changes live.
  • Automate the creation of Shopify “new product” import files in Excel.
  • Over 100 real life Excelify and Shopify app projects completed.
  • Support, help and consultancy provided in developing your systems and processes to work and integrate well.

Online Shopping Systems Excel Consultancy Services

  • Automated e-commerce data file creation eg for Shopify, Ebay, Amazon, Magento, File Exchange, “Simple Inventory” and Matrixify / Excelify applications
  • Extraction, manipulation and analysis of data from databases and other business systems.
  • Automated cross referencing Shopify data with supplier data files to speed up updates.
  • Automated stock and price updates for Amazon’s Inventory “Add Products via Upload” page using uploading automated Excel files.
  • Automated deletion of products not now in your live data streams.
  • Repricing systems and inventory systems created for online shopping software.
  • Analysis of Excelify and Shopify sales data to calculate profit margins, best sellers and stock movements.
  • Data file creation for new product e-commerce data for Shopify, Ebay, Amazon, Magento and Excelify applications.
  • Spreadsheet review and Quality Control check.
  • Bespoke spreadsheet design and development using Excel Macros (VBA).
  • Link Shopify to your Inventory systems through Excel spreadsheets and CSV files.
  • Use the power of Excel spreadsheets and macros to help and support you develop high speed accurate shopping websites.

Contact me to discuss your full requirements

Scroll to Top