Zoey integrates with SellerCloud by automatically importing and exporting files through an SFTP server!

To sync data between SellerCloud and Zoey, you will need to first connect both systems to one central location for file transfer.

SellerCloud Data Mapper Integration

🚧

Requires that SellerCloud is connected, and automatically exporting to/importing from an SFTP server.

Click here for to request a SellerCloud SFTP server.

Then a Zoey Data Mapper will be set up to perform the following import/export jobs.

• Export Zoey Order and Items
• Import Shipments & Tracking
• Import Product Inventory

Click here for general information on setting up a connection and data mapper in Zoey.

Create SFTP Folders

Create folders in your SFTP that match the example file structure shown below. These folders will facilitate the data transfer and contain historical archived files.

There are three main folders in Zoey SellerCloud Sync, each with archive folders as shown here.

One folder for each of the syncing functions between the systems. Copying this structure will make it easy to configure both systems.

Data Mapper Setup for SellerCloud Integration

📘

In your Zoey Data Mappers, first add an SFTP connection!

Click Add Connection and configure the new connection to your SellerCloud SFTP.

Save and Test Connection to make sure your authentication details are correct.

1. Orders Export to SellerCloud

With the Connection configured, we can set up the Order data export to SellerCloud

Setting up the Zoey Order Items export for SellerCloud

Click Add Data Mapper to begin creating the mapper. Here is a walkthrough of the important steps in creating an Order Data mapper that exports to SellerCloud:

1. Select SellerCloud SFTP from the Connection drop-down.

2. Give your mapper a name like "Order Items Export to SellerCloud".

3. Set the Schedule that will determine when, and how often, the Order Items data is exported to the SFTP. For example, the schedule below will export Order Items every hour, on the hour, starting at 12am each day.

   

4. Set Send Error Emails to Yes! Then enter email addresses which will be notified when if there is an error.

   ❗️

   Being notified of any errors is very important since an error will prevent the entire file from being processed. A single error on any of these mappers will stop the workflow for many orders.

Mapper Settings:

• The Zoey Object must be set to Order Items. Order Items will include each item on the order, allowing you to include their SKU and related data. Order's data will repeat for each item row.
• Type will be File Export by default, so no change there.

👍

Select the Standard Order Item Export Mapper Template.

• Set Use Variation Attributes depending on how configurable products should display attributes. This would typically be set to Yes.

• Set Export Bundle Selections to Yes for individual items in a bundled product to be exported. When set to No, the Bundle Product itself will be exported.

• Configure the File Settings:

  Enter the File Name to give the exported CSV file.

  Set the File Export Folder to /orders/ or whichever folder on the SFTP that the Order Items export should be sent to.

Field Mappings

The fields mappings here will determine the data being exported! Click + Add Field to add columns to the spreadsheet.

CSV Column will be the column header. Zoey Value is the data being exported from Zoey.

Here is a standard list of SellerCloud Sales Order import data fields in the CSV Column, and the appropriate Zoey Value next to them.

SellerCloud Order Data Mapper Fields

Hit Save! The data mapper is ready to automatically send your Zoey Orders to the SellerCloud SFTP.

👍

Order Items mapper has a Preview option which will let you download to test the export file you're building.

2. Product and Inventory Import from SellerCloud

Zoey can automatically import Product updates from SellerCloud. This can update your Zoey Products' inventory, price, name, shipping details, and any other attribute!

Setting up the SellerCloud to Zoey Product Update

1. Start creating a new Data Mapper and and choosing the same SellerCloud SFTP Connection.
2. Give your mapper a name like "Inventory and Product Data Update Import".
3. Then set Use Schedule to Yes and then set the Schedule which will determine when, and how often, the Product data is imported from the SFTP. For example, the schedule below will try to import Products once per hour, starting at 12:35am each day.

• Select the Zoey Object of Products and make sure Type is File Import.
• Choose the Zoey Product CSV Import Mapper Template. This is the standard Product Import.
• Set Ignore SKUs not in Zoey to Yes.

  📘

  When set to Yes, the Products which are not found in Zoey will be skipped. This prevents errors when import data isn't filtered.

File Settings

• Set the File Name that will be imported, and the File Import Folder where it will be found on the SFTP. If you're following our example then the folder should be named /products/
• File Format and File Extension should remain CSV by default.
• Set the File Action after Processing to Move File.
• File Folder After Processing should be /products/archive/ if following our example.

Hit Save and then we'll start adding the Header Mapping fields.

SellerCloud Product Update Import Field Mapping

The fields mapped here will determine what data is imported to Zoey from your SellerCloud Products! Any fields mapped here can overwrite the data currently set for their Product.

🚧

If you don't want the SellerCloud Product to overwrite certain data on the Zoey Product, then don't map that field here!

All mapped will be imported from your Product CSV to overwrite Zoey Product data.

Click + Add Field to add fields. Here is an example list of SellerCloud Product Export fields and their Zoey mapping counterpart.

👍

If you only want the Product Stock QTY to be updated in Zoey...

Just map the ProductID/SKU and the AggregateQty/qty. Any other fields you include in the mapping and file will sync to Zoey.

3. Shipment and Tracking Import from SellerCloud

This mapper enables Zoey to create Shipments, send customers the tracking details, and automate the invoicing, or payment collection.

Here is an example of how to set up the Shipment and Tracking Import from SellerCloud.

Setting up the SellerCloud to Zoey Shipment Import

1. Start creating a new Data Mapper and and choosing the same SellerCloud SFTP Connection.

2. Give your mapper a name like "Shipment and Tracking Import".

3. Then set Use Schedule to Yes and then set the Schedule which will determine when, and how often, the Shipments are imported from the SFTP. For example, the schedule below will try to import Shipments once per hour, starting at 12:50am each day.

   

• Select the Shipments Zoey Object.
• Change Type to File Import.
• Choose the ZoeyShipment CSV Import mapper template. Standard Shipment Import described here.
• A Shipment import can create the Invoice, send it, or even mark it paid! If that's right for your workflow the set Create Invoice and subsequent settings accordingly. Read the tooltips or click here for more info.
• Use Item SKU Fallback must be set to Yes!

  📘

  This means you cannot import a shipment that contains two different items with the same SKU. This shouldn't be a problem for most but if any unique Products will have the same SKU then please be aware.

File Settings

• Set the File Name that will be imported, and the File Import Folder where it will be found on the SFTP. If you're following our example then the folder should be named /shipments/
• File Format and File Extension should remain CSV by default.
• Set the File Action after Processing to Move File.
• File Folder After Processing should be /shipments/archive/ if following our example.

Hit Save and then we'll start adding the Header Mapping fields.

SellerCloud Shipment and Trcking Import Field Mapping

Click + Add Field to add fields. Here is an example list of SellerCloud Shipment fields and their Zoey mappings:

Manually Run a Data Mapper

👍

Make sure your import file is uploaded to the right folder on the SFTP with a name that matches what the mapper expects!

Data mappers can run manually by clicking the 3-dots on their right side in the general data mapper list. This is best for testing the import process.

To schedule the mapper to run automatically, set Use Schedule to Yes. Then configure how many times it should run per interval and the start time.

Your exports or imports should occur just before or after the Zoey mapper runs on a staggered schedule.