Stock like 10+ or "in stock" in a CSV: find and fix
Stock cells like 10+, 5-10 or in stock give no exact count, so an import may reject or misread them. Find them, enter real counts, then recheck.
पोस्ट पढ़ेंपोस्ट
प्रोडक्ट CSV में गलतियाँ ढूँढने और ठीक करने की छोटी गाइड, साथ में निर्माण से जुड़े अपडेट। पोस्ट अंग्रेज़ी में प्रकाशित की जाती हैं।
अभी इस्तेमाल करने का टूल
अपनी उत्पाद CSV में त्रुटियाँ खोजें
आयात की आम त्रुटियों के लिए 20 पंक्तियाँ जाँचें और सुधार के चरणों वाली रिपोर्ट डाउनलोड करें। मुफ़्त, साइन-इन की ज़रूरत नहीं। फ़ाइल आपके ब्राउज़र में रहती है।
क़ीमतें और संख्याएँ
Weight and size units in a product CSV: find and fix
A 250 g item shows as 250 kg? Pick one unit per measurement, split units from numbers, convert the rest, spot outliers, then recheck.
पोस्ट पढ़ेंFractional stock quantities in a CSV: find and fix
A stock of 2.5 or 0,5 can be rejected, rounded or split into an extra column. Find fractions with a helper column, fix them to whole units, recheck.
पोस्ट पढ़ेंDate columns in a CSV: serials, swaps, formats
Dates shown as 45992, day and month swapped, or three formats in one column. Find each problem, rebuild the column as yyyy-mm-dd text, then recheck.
पोस्ट पढ़ेंThousands separators in CSV prices: find and fix
Is 12,500 twelve thousand five hundred or twelve and a half? Find thousands separators in a CSV price column and rewrite them in one style.
पोस्ट पढ़ेंText in a CSV price or stock column: find and fix
Words like N/A, free or call us in a price or stock column can make an import skip or misread rows. Find them, write real numbers, then recheck.
पोस्ट पढ़ेंZero or negative CSV price and stock: find and fix
A price or stock of 0 or below can make a product look free or show wrong availability. Find the rows on a copy, fix them from your records, recheck.
पोस्ट पढ़ेंCurrency symbols in a CSV price column: find and fix
Prices like "$12.50" or "45 TL" can make an import reject or misread rows. Find the symbols on a copy, keep prices as plain numbers, then recheck.
पोस्ट पढ़ेंDecimal comma or column separator in CSV prices?
A comma in a price can be a decimal mark or a column separator. Learn how to tell them apart, fix a copy of your CSV, and recheck before you import.
पोस्ट पढ़ेंSKU और बारकोड
Size and colour variant rows in a CSV: find and fix
Variants on separate rows need their own SKUs and titles that fit their options. Sort by product, check each group, fix, then recheck.
पोस्ट पढ़ेंBarcode check digit errors in a CSV: find and fix
A barcode can have the right length and still fail because its last digit does not match. Check it by hand, copy the code again from the source, recheck.
पोस्ट पढ़ेंBarcodes shown as 1.23E+12 in a CSV: find and fix
A barcode column showing 1.23E+12 has been read as a number. Rebuild it as text from the source, then check the saved CSV in a text editor.
पोस्ट पढ़ेंDuplicate SKUs in a product CSV: find and fix
Shared SKUs can make an import reject, merge or overwrite products. Clean spaces and case, sort the whole table, then decide which row stays.
पोस्ट पढ़ेंWhy SKUs lose leading zeros in CSV files
Spreadsheet apps can read a digits-only SKU as a number and drop its leading zeros. Import the column as text and compare the export with your original.
पोस्ट पढ़ेंDuplicate SKU: what should I change?
Two different products share one SKU. A synthetic before-and-after example of fixing it without deleting a valid product.
पोस्ट पढ़ेंहेडर, पंक्तियाँ और खाली सेल
Line endings (CR, LF, CRLF) in a product CSV
Your CSV looks fine, but the import fails at the end of a row? See what CR, LF and CRLF are, how to spot them in a text editor, and how to change them.
पोस्ट पढ़ेंVery long text in a CSV cell: find and fix
Rows rejected as too long, or one cell holding several rows? Count the characters, fix missing quotes, shorten or move the text, then recheck.
पोस्ट पढ़ेंCSV opens in a single column: check the separator
Every row stuck in one cell in column A? Find the character between your values, pick it when importing, then recheck the columns.
पोस्ट पढ़ेंQuotes and commas inside CSV cells: find and fix
A comma or a quote inside a cell can push values into the wrong column. Wrap those cells in double quotes, double the inner quotes, then recheck.
पोस्ट पढ़ेंBlank rows in a product CSV: find and remove
Rows with nothing in them raise the row count and may cause upload warnings. Find fully blank rows with a filter, delete them, then count again.
पोस्ट पढ़ेंCSV column headers that don't match the template
An import can reject a product CSV over one header that differs from the template. Compare headers character by character, fix the header row, recheck.
पोस्ट पढ़ेंLine breaks inside a CSV cell: fix split rows
A line break or a stray quote inside a cell can split one product into two rows. Put the text back on one line, close every quote, then recheck.
पोस्ट पढ़ेंEmpty cells in your product CSV: why and how to fix
Empty cells in a product CSV usually come from four causes. Find them on a copy, fix each one, then check the file again before you import it.
पोस्ट पढ़ेंटेक्स्ट, लिंक और एन्कोडिंग
Duplicate product titles in a CSV: find and fix
Different products with the same title confuse shoppers. Compare titles ignoring case and spaces, tell variants from real duplicates, fix, recheck.
पोस्ट पढ़ेंImage links in a CSV: capitals, spaces and %20
Blue-Mug.JPG and blue-mug.jpg may be two different files. Check capital letters, edge spaces and %20 in your image links by hand, on a copy.
पोस्ट पढ़ेंHTML tags in CSV product descriptions: find and fix
Pasted HTML tags and codes like & can show up as raw text in product descriptions. Find them on a copy, clean them to plain text, then recheck.
पोस्ट पढ़ेंEmoji and invisible characters in a product CSV
Emoji, symbols like ™ and invisible zero-width characters can break a product import. Find them on a copy, swap in plain text, then recheck.
पोस्ट पढ़ेंCategory or brand names in a CSV: find and fix
"Shoes" and "shoes" can import as two categories. List the unique values, pick one spelling for each, replace the variants, then recheck.
पोस्ट पढ़ेंMissing column in a CSV import: check for a BOM
If an import says a column is missing although the name looks right, this post shows how to check a copy of the file.
पोस्ट पढ़ेंBroken image links in a product CSV: find and fix
A space, a doubled dot or a missing ending in an image link can hide a product picture. Check the column by hand and match each link to the real file.
पोस्ट पढ़ेंHidden spaces in a product CSV: find and fix them
A space at the start or end of a cell makes SKUs and prices stop matching. Find edge spaces by comparing lengths, trim them on a copy, then recheck.
पोस्ट पढ़ेंWhy accented letters look broken in your CSV
Turkish or accented letters look garbled in a CSV? Find the file's encoding, save a copy as UTF-8 and check it again without touching the original.
पोस्ट पढ़ेंफ़ाइल पर काम करने का तरीका
CSV correction worksheet: log each fix, recheck
A copyable template for recording each flagged row, the value you verified, the fix you made and the result of the recheck.
पोस्ट पढ़ेंCheck, fix, recheck: a product CSV before you use it
A use case, not proof of demand: how a solo founder can check a product CSV in the browser, fix it and check it again.
पोस्ट पढ़ेंअन्य पोस्ट
The starting point, in numbers
Revenue $0, no verified paying customers, and a catalog of 196 business ideas you can rate. Here is the honest picture on day one.
पोस्ट पढ़ें