This article explains
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">
<Query>select [Item Number] As [ItemId], SumOfSTK_Quantity As QuantityOnHand from vGTP_ItemsByLoc WHERE LOC_CardIdentification = 'AU-WH'</Query>
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">
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="firstname.lastname@example.org"/> <!—-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
List of Commands
- 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