SoldEazy Help and Support

Error: unknown columns in the datasheet

Error: unknown columns in the datasheet
Error: unknown columns in the datasheet

1. Open the Excel file
2. Find the rightmost column (usually DH). Select the blank column on its first right hand-side column (DI according to general case).
Quick way: click cell A1, then press ctrl + right (arrow) on the keyboard. It will jump to DH immediately. Then select column DI.
3. After selecting column DI, press ctrl + shift + right (arrow). At this moment, you will select all cells on the right hand-side. Press delete.
4. Find bottom row.
Quick way: click G1 which is certainly on a continuous column. Press ctrl + down (arrow) on the keyboard. It will jump to the last row immediately. Then select column DI.
5. Select the blank rows lower than the bottom row, press delete.
Quick way: Press ctrl + shift + down (arrow). Then you will select all cells below last row without empty cell. Press bottom delete.
-------------------------------------------------------------------------------
Please create a new xlsx by copying the parts you should upload. And save as a new Excel if the first method doesn’t work.

***Fin***

0 (0)
Article Rating (No Votes)
Rate this article
Attachments
There are no attachments for this article.
Related Articles RSS Feed
Your application has exceeded usage limit on this call, please make call to Developer Analytics API to check your call usage.
Viewed 1871 times since Fri, Mar 24, 2023
The item cannot be listed or modified···We noticed that you are attempting to sell inventory that is located in a different country. If this was an error, please return to the previous step to modify the item location.··
Viewed 3006 times since Fri, Jul 24, 2020
Error: Duration cannot be revised, possible reasons: the item has bid or active Best Offers or is ending in 12 hours, the item is a store item, or the item is an ad-format item.
Viewed 12955 times since Wed, Aug 29, 2018
The error of joining the promotion listing: The seller must accept the Promoted Listings terms and conditions
Viewed 2600 times since Fri, Jul 24, 2020
Error: Selected category is not enabled for variation listings.
Viewed 1408 times since Fri, Mar 24, 2023
Error:Duplicate VariationSpecifics trait value in the VariationSpecificsSet container
Viewed 5686 times since Wed, Aug 29, 2018
Error: You’ve provided an invalid shipping policy / return policy / payment policy.
Viewed 10201 times since Thu, Mar 23, 2023
Error: Duplicate name-value combination in variation specifics.
Viewed 3267 times since Mon, Aug 6, 2018
Error: Variations specifics and item specifics entered for a multi-SKU item should be different
Viewed 13269 times since Thu, Jul 30, 2020
Error : A coupon with this ’couponCode’ already exists. Please try a different ’couponCode’.
Viewed 1408 times since Wed, Mar 22, 2023