Shopify Ship Confirmation Export

Shopify Ship Confirmation Export

Module: Export
Path: Processing>Import/Export>Exports
Topic: Shopify Ship Confirmation Export
Version(s):  5.1 & up
Editions: All

What Is Shopify Ship Confirmation Export

The Shopify Ship Confirmation Export is used to pass payment and fulfillment details back to Shopify. With this export you also have the option to use Shopify's Ship Confirmation notification should you choose.

Making The Connection

Where Will I See This Within OLX?

The export runs based off the item status found on the Order Detail screen and updates Shopify.

What Reports Can Be Pulled?

  1. At this time there are no reports

What Imports/Exports Relate to Shopify Ship Confirmation Export

  1. Shopify Order Import

Trouble Shooting

  1. Shopify API response status and error codes

  2. ResponseCode: 422. Response: {"errors":["Invalid fulfillment order line item quantity requested."]}

    1. This means the order as already been confirmed in a previous export
      1. create a support ticket for OLX to review why backend table is not updating with this items information to keep it from repeatedly trying to export.

  3. ResponseCode: 429. Response: {"errors":"Exceeded 2 calls per second for api client. Reduce request rates to resume uninterrupted service."}


Setup

Prerequisites

Custom Values

Following custom values must be set Client level:

Oauth:
  1. Shopify_Subdomain (Required)
  2. Shopify_APIPassword (Required)
    1. This is where you put the Oauth token
  3. Shopify_LocationID (Required) 
  4. Shopify_Notify_Customer (optional)
    1. True/False
  5. Shopify_UseMyShopifySubDomain (optional)
    1. True/False
      1. ('y','yes','1','t','true') default is 'yes'
Basic Auth:
  1. Shopify_Subdomain (Required)
    1. Example:  Our store URL is https://orderlogixstore.myshopify.com/
    2. you would only put "orderlogixstore".
  2. Shopify_APIPassword (Required)
  3. Shopify_APIKey (Required for Basic auth type users - not needed for Oauth auth type users)
  4. Shopify_Authtype (Required)
    2. Basic
  5. Shopify_Notify_Customer (optional)
    1. True/False
  6. Shopify_UseMyShopifySubDomain (optional)
    1. True/False
      1. ('y','yes','1','t','true') default is 'yes'
  7. Shopify_LocationID (Required) 
    1. Finding LocationID in Shopify
      1. Go to Settings
      2. Shipping & Delivery
      3. Click on Manage under the Local Delivery section

      5. It is the number located after local delivery in the URL 
        1. Example:
          1. https://orderlogixstore.myshopify.com/ admin/settings/shipping/local_delivery/394XXXXX173

Shopify Admin API Access Scopes

The following permissions must be granted in Shopify for the export to work correctly between the two systems:
  1. Login to Shopify
  2. Go to Settings
  3. Apps and Sales Channels
  4. Develop Apps
  5. open the app you created for OLX integration with each client
  6. navigate to Configuration tab
  7. review access scopes
    1. specifically looking for the write + fulfillment scopes


To Use:

Navigate to Processing>Import/Export>Exports.

  1. Choose a client from the Client drop down list.
  2. Spec = Shopify Ship Confirm Export
  3. Set date range - this is the order date, not item status date
    1. Shipment Delivered and Item Paid are the statuses that are updated
    2. You can request other item statuses that are specific to your needs (this must be coded for)
  4. If partial order options are available for that spec
    1. Require payment of all other items on the order - will not allow any ship ready items into batch if all items are not ship ready regardless of product group(s) selected.
      This will keep orders with an item on backorder from being eligible for the remaining line items not in backorder.
    2. Require that ALL shippable items on the order are included in this export - 
      all ship ready items on order in product group(s) selected will ship in same batch
      If there are multiple shippable items on the order in different product groups and all product groups are not selected, none of the items will export with this option checked.
  5. Select an available product group, or multiple product groups, from the available list. 
    1. Move them to the selected list by clicking the right arrow. This product group will now be available for the export.
    2. To move all product groups from the available list to the selected list, click the double right arrow icon.
    3. To remove a product group, select a product group, or multiple product groups, from the selected list.
    4. To move it back to the available list click the left arrow. The product group will no longer be available when performing this export.
    5. To remove all product groups from the selected list, click the double left arrow icon.
  6. Click the Export button to perform the export.
  7. Once the process begins, you will see the results tab displayed; and it will state "Job ran successfully" when the file is complete. 

  8. There will be a "download" file link located in the results tab that allows you to save the file to your computer.
  9. The Delivery and Encryption tabs are associated with Automated Schedules. 


    • Related Articles

    • Shopify Order Import

      Module: Imports Path: Processing > Imports Topic: Shopify Order Import Version(s): 5.1 & Up Editions: All What Are Shopify Order Import This module is built for olx 5x and lets us import orders from the Shopify. It supports four payment gateways for ...

    • Flattened Export Definitions

      Module: Reports Path: Reports > Processing Reports > Flattened Export  Topic: Flattened Export  Version(s):  5.1 and up Editions: All What Is The Flattened Export? The Data warehouse Export and the Flattened Export are both very valuable reports in ...

    • Datawarehouse Export Definitions

      Module: Reports Path: Reports > Processing Reports > Data Warehouse Export Topic: Data Warehouse Export Version(s): 5.1 and up Editions: All What Is The Data Warehouse Export? The Data warehouse Export and the Flattened Export are both very valuable ...

    • R19.2 p14 Portal: Lock down some actions when orders have items awaiting shipment confirmation

      Version: 5.1 Patch: R19.2 p14 Title: Portal: Lock down some actions when orders have items awaiting shipment confirmation Application Category: Other, CS Funtionality (1) Patch Type: Feature Description: Customer Portal change: When an order has an ...

    • R19.2 p11 CS Agent: Lock down some actions when orders have items awaiting shipment confirmation

      Version: 5.1 Patch: R19.2 p2 Title: CS Agent: Lock down some actions when orders have items awaiting shipment confirmation Application Category: Other, CS Functionality (1) Patch Type: Feature Description: Some CS actions will be prevented when an ...