Description

This article provides information on ShopifyLink Adaptor setup.

Detail Steps

Information required during the setup.

The client’s Shopify user login name is typically an email.

Client’s Shopify user password.

The client’s Shopify website URL for API is typically in the format “https://xxx.myshopify.com” xxx is the Shopify shop name.

The location code for the client order to deduct stock from.

Card Name for the default customer card for all remote sales.

The default Shipping SKU.

Whether the customer wants to use a default card’s shipping method.


Location for the Shopify Link and install location

The ShopifyLink is located in the FTP, Folder: “/FTP/Partners/ShopifyLink”.

The ShopifyLink should be installed in: “<Datapel Systems Folder>\ShopifyLink” usually should be “C:\Program Files (x86)\Datapel Systems\ShopifyLink”.


Script to be setup

In the ShopifyLink folder, the following files are present for the setup of the additional script:

PK_ON_AFTER_SHIP.vbs – need to copy to the script folder

RICXMLTemplate.xml – need to copy to the script folder

PrefXML_ScriptEvent.txt – base on the text in this file, put the XML setting into pref.xml

StopAllDatapull.bat – to be run by Stop Waas schedule task.


Task need to setup in Task Scheduler

5 schedule tasks need to setup:

Waas – WMS as a service

Stop Waas – stop WMS as a service every night to prevent any locked process.

Upload Order Shipment Info

Download Shopify Order

Upload Shopify stock inventory.


Datapull to be added into the pref.xml

Need to add the following text config into pref.xml for datapull of items quantity, in section DataPulls/clsDataPulls/clsDataPullList :

<clsDataPull Index="3" Object="True">

<Tag>Shopify_Items</Tag>

<Filename>C:\ShopifyLink\items_AU_WH.txt</Filename>

<AfterCount>20</AfterCount>

<WidthMap></WidthMap>

<UseHeader>True</UseHeader>

<Style>TSV</Style>

<FieldMap></FieldMap>

<PaddingMap></PaddingMap>

<Query>select [Item Number] As [ItemId], SumOfSTK_Quantity As QuantityOnHand from vGTP_ItemsByLoc WHERE LOC_CardIdentification = 'AU-WH'</Query>

</clsDataPull>

The query may need to modify according to the user requirement.


And this in the script section Scripts/clsScripts/clsScript:

<clsVBScript Index="1" Object="True">

<Key>PK_ON_AFTER_SHIP</Key>

<Enabled>TRUE</Enabled>

<VBScript>PK_ON_AFTER_SHIP.vbs</VBScript>

</clsVBScript>


Configure the configuration file: Datapel.WMS.ShopifyLink.exe.config

In the web config have the following need to configure:

<!--Datapel Test Store Login-->

<add key="Shopify.UserName" value="mk.liew@datapel.com"/> <!—-the login of user gave to us -- >

<add key="Shopify.Password" value="d@t@p3l"/><!—-the password for the user login -- >

<add key="Shopify.Shopname" value="datapel-system-test-store"/><!—-the client’s web store name -- >

<add key="Shopify.DefaultHOSKU" value=" "/><!-- Need to configure, can be blank-->

<add key="WMS.ProductFiles" value="c:\shopify"/><!-- Need to configure, location for the item.txt that exported from wms-->

<add key="StoreCode" value="AU-WH"/><!-- Need to configure, location for item quantity data that to be upload-->

<add key="CardName" value="Internet sales"/><!-- Need to configure, Card to be use for all online order-->

<add key="ShippingSKU" value="FREIGHT"/><!-- Need to configure-->


Authorise the app from the client’s web store admin page

Figure 1: Shopify Dashboard

Initial Login on User Store for validation on whether the App is already installed or not.

Figure 2: App Store

If the App Store is installed and ready to use, it will be avaible to Visit the App Store as shown.

Figure 3: Authorization

Setup the ShopifyLink with the given command above to ensure the Authorization is taking place.

Figure 4: Login

Login into Client’s Store, which is Datapel test store for checking.

Figure 5: Browser Security

Proceed by clicking on the “continue using your old browser”.

Figure 6: Install App

  1. Datapel.WMS.ShopifyLink A\

  • For Authorization purposes for first time setup (usually).

2. Datapel.WMS.ShopifyLink 1

  • Download All Orders

3. Datapel.WMS.ShopifyLink 2

  • Update Order Note

4. Datapel.WMS.ShopifyLink 3

  • Update Product Variant Quantity

5. Datapel.WMS.ShopifyLink 4

  • Update Order Fulfillment

6. Datapel.WMS.ShopifyLink 5

  • Download All Orders

7. Datapel.WMS.ShopifyLink 6

  • Download Single Order


Related Information

WMS shopify adaptor