Configure SellerCloud to SPE Express Connector
Instructions on how to create the connection between SellerCloud and SPE Express.
Configure Custom Settings
- Go to Settings > Company Name
- Click Toolbox > Custom Settings
-
Enter the following:
- CompanyOrderPrefix: (2-3 digit client code)
- SPExpress Customer Name. Example: 1LIVE (Global Merch) or 1LIVECORP (Merch Collective)
- SPExpress Dallas WarehouseID: 121
- SPExpress Ontario WarehouseID: 118
- SPExpress Order Prefix (2-3 digit client code)
- Click Save.
Create Saved Search
- Go to Orders > Search Orders
- OrderStatus: InProcess
- Exported: Not Exported
- PaymentStatus: Charged
- Shipping Status: Unshipped
- CompanyID: (insert store warehouse)
- Select Saved Search As and name it "(Client Code) SP Order Export" Example: AS SP Order Export.
- Click Save.
Create Scheduled Task
- Go to Settings > Company Name
- Click Toolbox > Scheduled Tasks
- Create new task from the pulldown "Export Orders"
- Name it "EXPORT ORDERS - SP EXPRESS"
- Check "Schedule Enabled"
- Start Time: Today's Date
- Enter Recurrence: Every 30 minutes
- Expire Schedule: Never
- User ID: Select your email address
- Saved Search: Select search you created (from Create Saved Search)
- Export via Plugin: OLM SP Express Format
- File Name: orders-ddMMyyyy-hhmm02
- Export To: FTP (see FTP Login Info below)
- Click Save.
FTP Login Info
Global Merch FTP Server: ftp.spexpress.com FTP User: onelive FTP Password: SuNV78P$gx3 FTP Port: 21 Remote Folder: Shopify-Orderfiles
Merch Collective FTP Server: ftp.spexpress.com FTP User: onelivecorp FTP Password: 3q2A{3e67&g FTP Port: 21 Remote Folder: Shopify-Orderfiles