Setup for ShopifyLink Adaptor
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
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