ChatGPT JSON to Markdown
Convert a local ChatGPT export into readable Markdown. Preview a conversation or download a ZIP of notes for Obsidian.
Open tool →Paste up to 5,000 barcodes to check them all at once, or add the check digit to base numbers. It also finds the damage spreadsheets do to product codes.
Example codes are shown. Paste up to 5,000. Nothing leaves your browser.
The last digit of a GTIN, UPC or EAN is worked out from the others, so a scanner can spot a misread. Every format uses the same steps:
Take the first twelve digits of an EAN-13: 590123412345.
The full code is 5901234123457. Because the multipliers start from the right, leading zeros don't change the result. That is why a UPC and its 13-digit form share a check digit.
Most broken barcodes in a product file were correct before someone opened it in a spreadsheet. A column formatted as numbers does two kinds of damage:
To avoid both, format the column as text before you paste codes into it.
Since version 9.2, WooCommerce has a "GTIN, UPC, EAN, or ISBN" field on products and variations. The behaviour below was tested by importing files through the WooCommerce 11.2.1 importer:
Store the code in the same form that your scanner reads it. A lookup that compares text won't match 12345678905 to a scan of 012345678905.
This tool tests the arithmetic. It can't tell you whether a code has been assigned, or to whom. To sell on marketplaces or through retailers, get your codes from GS1 or use the ones your supplier printed on the product. For items that only ever move inside your own shop, a SKU is usually enough.
Some prefixes are reserved. Codes starting with 200 to 299 or 020 to 029 are restricted-circulation numbers, used for things like items weighed in store, so they shouldn't identify a product on the open market. The tool flags those, along with book, periodical and coupon prefixes.
Starting from the right of the number without its check digit, multiply the digits by 3, 1, 3, 1 and so on, then add the results. The check digit is whatever brings the total up to the next multiple of 10. All GTIN formats use this method.
GTIN is the family name. A UPC-A is a GTIN-12, an EAN-13 is a GTIN-13, an EAN-8 is a GTIN-8, and a GTIN-14 is used for cases and cartons. A UPC with a zero added to the front is the same product code as an EAN-13.
A spreadsheet treated the column as numbers and removed the leading zero. Paste the code here: if it becomes valid with the zero back, the tool shows the repaired code. To prevent it, format the column as text before pasting.
A spreadsheet converted it to scientific notation. If the file was saved like that, the last digits have been replaced with zeros and can't be recovered, so go back to the original source and format the column as text.
No. It shows that the arithmetic is right, not that the code has been assigned or whose it is. For marketplaces and retailers, get codes from GS1 or use the ones your supplier printed on the product.
No. When we tested the WooCommerce 11.2.1 importer, it saved a code with a wrong check digit without a warning. It does reject a code already used by another product, but it compares the text, so the same code with an extra leading zero gets through.
Stocktake matches scanned barcodes against your SKUs and WooCommerce's GTIN field, using a scanner gun or a phone camera (in beta). Review the differences, then apply them with a backup and one-click undo.
Explore Free and Pro →Read the step-by-step guideConvert a local ChatGPT export into readable Markdown. Preview a conversation or download a ZIP of notes for Obsidian.
Open tool →Open a WooCommerce stock CSV, count products in a browser worksheet, or download a printable inventory count sheet PDF. Review differences and export your count record.
Open tool →Turn daily demand, supplier lead time and safety stock into a reorder point and stock-position check.
Open tool →Generate up to 500 variations and a draft product CSV, or review an existing variation CSV for parent links, SKUs, prices and local attributes.
Open tool →Work out buffer stock from demand and lead-time variation at the service level you choose, with a reorder point.
Open tool →Find the cheapest order size, rounded to your pack size and supplier minimum, and compare it with what you order now.
Open tool →See how often you sell through your stock, how long it sits, and the cash a higher turnover would free.
Open tool →See how much of your stock has sold, how long the rest will last and when you'll reach your target.
Open tool →Download a template for any product type, and catch rows that will fail or silently import the wrong data.
Open tool →Turn product names and attributes into readable, unique SKUs, with a list or a WooCommerce import file to download.
Open tool →Sort products into A, B and C classes by value, straight from a WooCommerce export or a pasted list.
Open tool →Work out your shrinkage rate on stock, cost of goods sold and sales, and see which lines lost the most.
Open tool →See how much gross margin each unit of money in stock earns, and the cash a target would free.
Open tool →