Commerce 7: Export and Import CSV or XLSX files -or- Connect data to other apps.

Use EasyCSV to automate sending Commerce 7 CSV and XLSX files to FTP, Email, Dropbox, Google Drive, Microsoft OneDrive, Amazon S3, and more. Also, connect Order data to other apps or APIs

Quick Links:

  1. Export: Connect Commerce 7 to EasyCSV and set up an Orders export schedule
  2. Import: Import CSV or XLSX files into Commerce 7 to update Inventory, Create Customer Records, Create Orders, Create Products, and anything else the Commerce 7 API can do.

Connect Commerce 7 to EasyCSV and set up an Orders export schedule

  1. Log into your Commerce 7 account.
  2. Go to Apps & Extensions > Apps in the left-hand nav.
  3. Search for and install the EasyCSV App
  4. Log into EasyCSV
  5. Use the import flow that is already created for you. If one is not created then create a new EasyCSV import flow and page by selecting the button to make a new Import Flow and choose Commerce 7 as your data source.
  6. Choose where you want to send the Commerce 7 Order data when setting up the EasyCSV import flow & page. Popular destinations include emailing the data as a CSV file, uploading to FTP, Dropbox, Google Drive, Microsoft OneDrive, Amazon S3, and Box. You can also choose Zapier or Send to any App or API to send data into another app. If you need help setting up pushing data to another app please reach out to EasyCSV support via chat or email. We get back to everyone.
  7. After the page is created, click the "Scheduled Fetcher" link at the top of the page.
  8. Choose your export schedule timing details
  9. Choose to get the order data from Commerce 7
  10. Choose whether to seperate each order or keep them grouped. Each line item in an order will become a row of data sent to the destination.
  11. Save the scheduled fetcher settings.
  12. Go to the Import Flow link at the top of the page.
  13. Scroll to the bottom of the import flow page and fill out any missing destination info. Including the output file name you would like if you are creating a CSV or XLSX file.
  14. To test the whole flow go back to the schedule fetcher and click the "Force Fetch" button. Follow the video above for all of these steps.

Import CSV or XLSX files into Commerce 7: Update Inventory, Create Customer Records, Create Orders, Create Products, and anything else the Commerce 7 API can do

  1. Log into your Commerce 7 account.
  2. Create a Staff Account to use as the account that helps connect Commerce 7 data to EasyCSV. Instructions by Commerce 7
  3. Log into EasyCSV
  4. Create a new EasyCSV import flow and page by selecting an example CSV or XLSX file you plan to import.
  5. Choose to send data to any App or API when finalizing the initial setup.
  6. At the top of your import page, select "Import Flow" at the top of the page.
  7. Scroll down to the bottom of the import flow.
  8. Put in the API URL we want to post the data to. For the Commerce 7 API, you will enter: https://api.commerce7.com/v1/{endpoint you want to hit}. You can find the endpoint you want in the Commerce 7 API Docs
  9. Back in your Import flow. Click to add Request Headers
  10. The first request header will be the key "tenant" and the value will be your Commerce 7 subdomain. If you Commerce 7 URL looks like this "https://spectrawinery.admin.platform.commerce7.com" then your tenant value will be "spectrawinery". Save.
  11. Add a second request header with the key "Authorization" and the value being "Basic XXXXXXXXX". Replace "XXXXXXXXX" with a value that is your username/login plus your password hashed into a token. You can generate your Basic Auth Token here and copy / paste it back into EasyCSV.
  12. The last thing to do is to specify the structure of the data to send into Commerce 7. Go back to the Import Flow, and choose the "Customize JSON to Post" option.
  13. Enter the custom JSON and specify the CSV/XLSX values you want to use. Follow the video above or check out these docs for Customizing the JSON to post. You can also group rows in your file if you are on the EasyCSV Business Plan and above. Here are the Commerce 7 API Docs for finding the JSON to copy, paste, and replace.
  14. Once you have put in all your Commerce 7 API information you are ready to do some imports. Always do intial tests with small files with a small number of rows. When confident the data looks like the way you want it in Commerce 7, then do large file imports.