Description

This article explains 

Detail Steps

Information required during the setup.

Client’s shopify user login name, normally is an email.

Client’s shopify user password.

Client’s shopify website url for api, normally is 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 want 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” normally should be “C:\Program Files (x86)\Datapel Systems\ShopifyLink”.


Script to be setup

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

PK_ON_AFTER_SHIP.vbs – need to copy to script folder

RICXMLTemplate.xml – need to copy to 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

There are 5 schedule task need to setup:

Waas – WMS as a service

Stop Waas – stop WMS as a service on 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 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 able 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 click on the “continue using your old browser”.

Figure 6: Install App


For the First time, it will ask to Install App as above screen. If the App already installed, it will show you the Dashboard page or notify you on installed App.


Figure 7: Completed


App installed.


List of Commands


1.Datapel.WMS.ShopifyLink A\

  • For Authorization purpose 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

None