Actions & Action Templates
Inviting New Users
Partnership Billing Settings
Setting Billing Address
Single Sign-On (SSO)
Terms of Service
Check Order Status
Packing Slips - Buyers
Sending Test Orders
Signing Up As A Buyer
Syncing Order Updates
Connecting Your Platform
Fixing SKUs in Scientific Notation
How to Set Up Pricing
Marking Products Active
Seller Quickstart Guide
The 4Ps of Seller Onboarding
Adding a Buy Button to a Shopify Store
Creating Product SKUs
Downloadable Image Links
How Invoicing Works
Packing Slips - Sellers
Building API Integrations
Connecting through EDI
Connecting through SFTP
Connecting through Seller EDI
Connecting through Seller EDI - Advance Ship Notice (856) Specification
Connecting through Seller EDI - Inventory Update (846) Specification
Connecting through Seller EDI - Invoice (810) Specification
Connecting through Seller EDI - Purchase Order (850) Specification
Connecting through Seller EDI - Purchase Order Acknowledgements (855) Specification
Connecting through Web App
Getting Started with the Buyer API
How Inventory Sync Works
Integrating your CRM
Supported Connection Methods
Updating Shipping Information
Downloading EDI Files related to Purchase Orders
How to Resend an Advance Ship Notice
How to Resolve " Your SFTP user requires delete permission on your SFTP server."
How to Resolve "Already Processed Files"
How to Resolve "Unable to access your SFTP server"
How to Resolve "Your SFTP user requires read permission on your SFTP server"
How to Resolve "Your SFTP user requires write permission on your SFTP server."
Migrating Ecommerce Platforms
Using REF Segments for Identifying Vendors instead of an ISA ID
Updated by Kyle Tymoszewicz
Both files require a seller to list their Product SKUs. However, some spreadsheet editors such as Microsoft Excel can convert a seller's SKUs to scientific notation.
Normal SKU: 4172043946189
Scientific Notation: 4.17+E12
If you'd like to proceed with editing data in Excel, the below steps show how to resolve this issue.
Managing Column Width
The first step is to ensure that your column for SKU is wide enough to display the full width of values. You can drag the column width to fix this.
Changing the Data
Once the column width is fixed you can change the data type:
- Select the column for SKU
- Click the dropdown for the data type
- Change the data type to Text
To confirm success, you can open your CSV in a text editor like Notepad and search for "e+" and "E+".
If no values are returned then your SKUs have not been saved in scientific notation.
If issues persist, please contact support.