SFTP Integration
Import orders automatically from CSV files via secure SFTP connections.
Import orders into a manual shop by uploading CSV files over SFTP.
Setting Up SFTP Integration
- Open Settings → Integrations (opens the Cybership dashboard in a new tab) and choose Add Integration → SFTP.
- Name the integration and select the manual shop that should own imported orders.
- Connect the integration and save the generated credentials securely. Additional credentials can be created with Add Credential.
- Connect your SFTP client and upload a correctly formatted CSV.
SFTP Connection Details
| Setting | Value |
|---|---|
| Hostname | sftp.cybership.io |
| Port | 41955 |
| Protocol | SFTP |
| Authentication | Generated username and password |
Verify the server identity in your SFTP client. Keep credentials private; regenerate an exposed credential and update the uploading system.
CSV File Format
Include a header row and all 20 columns in this exact order. The importer reads positions, not header names. Leave optional values empty without removing their columns. Quote values containing commas and avoid embedded line breaks.
order_number,email,first_name,last_name,ship_name,company,address1,address2,city,province,country_code,zip,phone,total_price,total_tax,total_shipping,currency,sku,quantity,price
ORD-001,jane@example.com,Jane,Doe,Jane Doe,,456 Oak Ave,,Los Angeles,CA,US,90001,,40,0,0,USD,SHIRT-BLU-M,2,20| Columns | Meaning |
|---|---|
order_number | Stable external order identifier |
email, first_name, last_name | Customer contact |
ship_name, company, address1, address2, city, province, country_code, zip, phone | Shipping recipient and address; use a two-letter country code |
total_price, total_tax, total_shipping, currency | Order totals and currency |
sku, quantity, price | Item SKU, quantity, and unit price |
Use complete shipping details and numeric totals, quantities, and prices. SKUs must match products owned by the shop's merchant.
Multiple Items Per Order
Repeat the same order_number on each item's row and keep order-level details consistent. Within one file, rows with the same order number are grouped; repeated SKUs have their quantities added. Order-level details come from the first row.
An existing order is matched by merchant and external order number. Re-uploading can update that order; do not reuse an order number for a different order, including across the same merchant's shops. Send the intended complete order contents when correcting an import.
Monitor Imports
Uploading queues processing; it does not mean every order was created. Review the integration logs and resulting orders.
A CSV parsing error rejects the file's parsed orders. After parsing succeeds, orders process separately; missing product SKUs can cause an order to be skipped. Correct the reported problem and check existing orders before re-uploading.
Tracking emails can be configured on the integration when needed.
Managing Credentials
Use Update Credentials to regenerate or delete a credential. Regeneration replaces the password; update every client using it. Deleting a credential removes that uploader's access. Keep a working credential for systems that must continue uploading.
Troubleshooting
For connection failures, check the hostname, port, network, and current credentials. For import failures, check all 20 column positions, numeric values, complete addresses, and merchant-owned SKUs, then inspect the integration logs.