Getting Started on Convictional
Signing Up As A Buyer
Signing Up As A Seller
Single Sign-On (SSO)
Step by Step for Buyer Onboarding
Step by Step for Seller Onboarding
Successful Support Interactions
Adding Barcode Values in WooCommerce
How can I confirm that Convictional can pull my Products from my WooCommerce Store?
Updating your WooCommerce URL
CSV managed account
Connecting through SFTP
Downloadable Image Links
Fixing SKUs in Scientific Notation
How to Resolve " Your SFTP user requires delete permission on your SFTP server."
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."
Building API Integrations
Getting Started with Webhooks
Getting Started with the Buyer API
How to Create an Order for the Buyer API
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
Downloading EDI Files
How to Create a Test Order as an EDI Seller
How to Resend an Advance Ship Notice
How to Resolve "Already Processed Files"
Seller EDI Quick Reference
Migrating Ecommerce Platforms
Supported Connection Methods
How to Change Your Commerce Type
Integrating your CRM
Inviting Team Members
Managing Multiple Accounts
Setting Billing Address
Viewing Subscription Info
Actions & Action Templates
How to Determine the Remaining onboarding steps for a Partner
Buyer Product Validation Guide
Exclusive Collaborations - Syncing Unpublished Products
How Inventory Sync Works
How to Solve Shopify "Item Not Recognized" Error
Marking Products as Active or Inactive
Create a Price List For a Smaller Catalog
Editing Price Lists
How to Set Up Pricing
Price List FAQs
Promotional Price Lists and Discounts
Check Order Status
Fixing an Order Sync Timeout Error
Fulfilling orders from your ecommerce platform
Packing Slips - Buyers
Packing Slips - Sellers
Sending Test Orders
Configuring Per-Order Fees
How Invoicing Works
How to Delay an Invoice
Partnership Billing Settings
Understanding Per-Order Fees
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.