Trade details upload

Trade details upload:

Description:

The trade details upload process involves securely transferring transaction data from the e-commerce platform to the Infinia system using the SFTP (Secure File Transfer Protocol). This method is essential for ensuring that all sales, returns, and exchanges are accurately recorded and transmitted securely. The use of SFTP allows for the safe transfer of large datasets, maintaining data integrity during the upload process. Use this process to ensure your trade data is correctly and securely uploaded to Infinia.

SFTP account and address provided by Infinia

Trade details:

SFTP File Naming Rules: YYYYMMDD_SellerID_E-CommercePlatformFileId.csv

Example: 20240815_123456_1q2w3e4r5t6y.CSV (template in Appendix)

Note:

Please upload the file in CSV format.

Ensure no values contain commas.

Use N/A for any blank fields.

Separate multiple product details within the same orderId using $.

Upload the file to the SFTP directory that matches the SFTP account name using the SFTP address, account, and password provided by Infinia.

The file name and orderId must be unique.

If there are any errors in the file, it will not be processed. You can later obtain the error file download link via the query interface.

The error file will be based on the original uploaded file, with an additional column named status at the far right, marking each row as success or failed.

The error file download link will be valid for 10 minutes.

File names must not be duplicated, even for previously incorrect or unprocessed files.

The SFTP directory is automatically scanned every 30 minutes. To avoid errors caused by scanning incomplete uploads, prefix the file name with a period (.), e.g., .YYYYMMDD_SellerID_E-CommercePlatformFileId.csv. Remove the . after the upload is complete to make the file visible.

The transactionTime must be within 360 days.

Parameter	Datatype	Length	Required	Description
sellerId	String	64	M	Globally unique ID for each seller on E-commerce platform
orderId	String	64	M	The PI/CI number
sku	String	32	M	Stock Keeping Unit
transactionTime	Timestamp		M	Transaction Time
transactionCurrency	String	3	M	“CNH”
transactionAmount	String	64	M	The amount corresponding to the goods. 2 decimals
productType	String	3	M	Refer to appendix
productName	String	128	M	The specific name of the product
productQuantity	String	16	M	The specific quantity of the product.
productUnitPrice	String	16	M	The unit price corresponding to a single product. 2 decimals
shippingStatus	String	16	M	“Not Shipped”, “Shipped”.
estimatedShippingTime	Timestamp		C	Must be filled in when the status is "Not Shipped." Not required if already shipped.
logisticsTrackingNo	String	64	C	Must be filled in if the status is "Shipped." Not required if not shipped.
logisticsCompany	String	512	C	Must be filled in if the status is "Shipped." Not required if not shipped.
shippingTime	Timestamp		M	The actual shipping time.
country	String	3	M	Trade Country
storeUrl	String	2048	M	The product display website of the company.
buyerName	String	512	O	Buyer’s Name
buyerAddress	String	2048	O	Buyer’s Address