Shopify Ship Confirmation Export

Shopify Ship Confirmation Export

Info
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
        1. write_third_party_fulfillment_orders,
        2. write_fulfillments,
        3. write_assigned_fulfillment_orders, 
        4. ​write_merchant_managed_fulfillment_orders,
        5. write_content,
        6. write_customers,
        7. write_orders,
        8. write_products,
        9. write_translations,
        10. write_themes,
        11. write_shipping,
        12. write_script_tags,
        13. write_resource_feedbacks,
        14. write_reports,
        15. write_product_listings,
        16. write_price_rules,
        17. write_order_edits,
        18. write_online_store_pages,
        19. write_marketing_events, 
        20. write_locales,
        21. write_legal_policies,
        22. write_inventory,
        23. write_gift_cards, 
        24. write_draft_orders,
        25. write_discounts,

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.
      Alert
      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
      Alert
      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 ...

    • Shopify Order API Export

      Module: Export Path: Processing > Import/Export > Exports Topic: Shopify Order API Export Version(s): 5.1 & Up Editions: All What IS Shopify Order API Export Shopify Order API Export allows you to export orders from your OLX instance into Shopify. ...

    • Export Error: Server error 4: Failure

      You may encounter one of the following errors when attempting to deliver/export a file to an FTP/SFTP/FTPs server: ---------------------------- Job starting... Attempting to send test file Unable to send test file. Server error (4): Failure ...

    • How to Set Default Columns for the Datawarehouse Export and the Flattened Export

      The Datawarehouse Export and the Flattened Export are both very valuable reports in OrderLogix because they allow you to retrieve data in many different combinations, some of which may not be available from other default reports. These reports allow ...

    • Export delivery via sFTP, FTPS or FTP Failing

      Problems with firewalls and setup are the most common problems with export delivery. OLX v4.0 supports sFTP, FTPs and FTP. Please verify that you have submitted a Firewall Rule request to OrderLogix for the IP address of the FTP site. Please verify ...