My Account
Actions & Action Templates
How to Change Your Commerce Type
Inviting New Users
Managing Notifications
Partnership Billing Settings
Passwordless Sign-in
Privacy Policy
Setting Billing Address
Signing Up
Single Sign-On (SSO)
Switching Between Accounts
Terms of Service
Viewing Subscription Info
Buyers
Automating Price List Creation via Actions
Autonomous Merchandising
Buyer Product Validation Guide
Check Order Status
Downloading Assets
How to Delay an Invoice
Inviting Sellers
Packing Slips - Buyers
Selecting Products
Seller SLAs
Shopify Product Syncing
Signing Up As A Buyer
Step by Step for Buyer Onboarding
Syncing Order Updates
Wholesale Guide for Buyers
Sellers
Onboarding
Adding Partners
Connecting Your Platform
Exclusive Collaborations - Syncing Unpublished Products
Fixing SKUs in Scientific Notation
How to Set Up Pricing
Marking Products as Active or Inactive
Seller Quickstart Guide
The 4Ps of Seller Onboarding
Resources
Adding Barcode Values in WooCommerce
Creating Product SKUs
Downloadable Image Links
Handling Returns
How Invoicing Works
Importing Products
Inviting Customers
Manual Fulfillment
Packing Slips - Sellers
Taxes and Manual Invoicing
Wholesale Guide for Sellers
Editing Price Lists
Sending Test Orders
Step by Step for Seller Onboarding
Integrations
WooCommerce
Shopify
Connecting Shopify
Updating Permissions for the Convictional App on Shopify
Updating Shopify Store URL
EDI
Connecting through Seller EDI - Invoice (810) Specification
Connecting through Seller EDI for Dropship
Connecting through Seller EDI for Dropship - Advance Ship Notice (856) Specification
Connecting through Seller EDI for Dropship - Inventory Update (846) Specification
Connecting through Seller EDI for Dropship - Purchase Order (850) Specification
Connecting through Seller EDI for Dropship - Purchase Order Acknowledgements (855) Specification
Connecting through Seller EDI for Wholesale - Advance Ship Notice (856) Specification
Connecting through Seller EDI for Wholesale - Purchase Order (850) Specification
Webhooks
Building API Integrations
Connecting BigCommerce
Connecting Easypost
Connecting Magento 2 - Buyer
Connecting Magento 2 - Seller
Connecting through SFTP
Getting Started with the Buyer API
How Inventory Sync Works
Integrating your CRM
Supported Connection Methods
Updating Shipping Information
Security
Tutorials
Downloading EDI Files related to Purchase Orders
How To Update All Margins In A Price List
How can I confirm that Convictional can pull my Products from my WooCommerce Store?
How to Create a Test Order as an EDI Seller
How to Create an Order for the Buyer API
How to Determine the Remaining onboarding steps for a Partner
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."
How to Total Number of some kind of Resource using the API
How to check if you are a buyer or seller on Convictional?
Migrating Ecommerce Platforms
Troubleshooting
- All Categories
- Sellers
- Onboarding
- Fixing SKUs in Scientific Notation
Fixing SKUs in Scientific Notation
Updated
by Kyle Tymoszewicz
Convictional uses CSV templates to Import Products and Create Price Lists.
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

Confirming Success
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.
Continuing On
Your Products CSV or Prices CSV should now contain accurate SKU information. Please proceed with uploading your file to the respective page (Products or Prices).
If issues persist, please contact support.