All Collections
Integrations
Zapier
Importing Sales orders from Shift4Shop (formerly 3dcart) to Katana
Importing Sales orders from Shift4Shop (formerly 3dcart) to Katana

A guide for setting up the import of Sales orders from Shift4Shop to Katana via Zapier

Dayvid Lorbiecke avatar
Written by Dayvid Lorbiecke
Updated over a week ago

This is a guide for setting up the import of Sales orders from Shift4Shop (formerly 3dcart) to Katana via Zapier. You can use a similar approach for importing Sales Orders to Katana from other apps available on Zapier.

3dcart rebranded in the beginning of 2021 and is now known as Shift4Shop. Their Zapier integration still bears the old name and logo, but works seamlessly with the new platform.

If you want to learn more about Zapier, check our Zapier integration overview.

To start importing Sales orders from Shift4Shop to Katana:

1. In your Zapier account, create a new Zap.

2. Enter a name for the Zap.

3. Choose a trigger:

- Find and select "3dcart".

- Select a Trigger event: "New Order". This will start the Zap every time a new order is created in Shift4Shop (3dcart).

- Choose your Shift4Shop account and log in.

You can then test the trigger and continue.

4. Choose an action to find or create a customer:

- Find and select "Katana".

- Select an Action Event: we recommend selecting "Find customer" as the first action. This will enable you to match customers in Shift4Shop (3dcart) to your customers in Katana and avoid creating duplicates.

- Choose your Katana account and log in.

- Select a "Search By" field. This is a field in Katana that is used for matching the customer from the order. This is typically a unique identifier for the customer and we are going to use the e-mail address in this case.

- Select a Search Term. We are going to select "Billing Email" from Shift4Shop.

- If you wish to create new customers in Katana if a matching e-mail does not already exist, enable "Create Katana MRP Customer if it doesn't exist yet". Then map the fields from Shift4Shop (3dcart) to respective fields in Katana.

You can now test the action and continue.

5. Create an action to create a sales order:

- Click on the "+" button at the end of your workflow.

- Find and select "Katana".

- Select an Action Event: "Create Sales Order".

- Choose your Katana account and log in.

- To fill in the “Customer ID”, go to "Custom", then “2. Find or Create Customer in Katana MRP” and select "ID" from the Katana section. This ID is not visible in the Katana user interface, but we recommend using it as a Customer ID in the Zap as it is a unique identifier.

Important! Zapier expects Katana Customer ID to be inserted here. Katana ID was matched or created in the previous step “Find or Create Customer”.

- As an Order Number, choose an appropriate identifier from Shift4Shop (3dcart) fields. We recommend using "Invoice Number" paired with the keyword “S4S-“ and the "Invoice Number Prefix". This will generate orders “S4S-AB-1001”, ”S4S-AB-1002”, etc., which will help you to easily identify Shift4Shop orders in Katana.

- Choose a Katana Location to which you wish to send all sales orders from Shift4Shop (3dcart) with this Zap. Clicking on the Location field will display the list of all existing Locations on your chosen Katana account.

- Choose “Created Date”. Choose a field from Shift4Shop which indicates the creation date of the sales order, for example "Order Date".

- Choose “Delivery Date”. There is no delivery date field available in Shift4Shop. You can leave it empty and let Katana calculate it based on your default delivery settings or create your own calculation based on “Created Date”.

- Choose the “Order Item List Item ID”, “Order Item List Item Quantity”, and “Order Item List Item Unit Price” columns from Shift4Shop (3dcart) to respective fields in Zapier.

Important! The Variant SKU for an item on a Sales Order line must already exist in Katana. If the Variant SKU does not yet exist in Katana, then the sales order (line) will not be imported to Katana. New items cannot be created in Katana via Zapier.

- Choose a Tax Rate ID. You cannot map a Tax Rate from Shift4Shop to a Tax rate in Katana at a sales order or sales order line item level (if you have taxes enabled for your product). All sales orders and line items will be assigned the same chosen tax rate (from the list that includes all existing tax rates in Katana).

Continue and test the action.

Your Zap for importing Sales orders from Shift4Shop (3dcart) to Katana is now ready for turning on!

Did this answer your question?