<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Rayan</title>
    <description>The latest articles on DEV Community by Rayan (@fichasync).</description>
    <link>https://dev.to/fichasync</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4257840%2F86ec56c4-1d1d-4e15-975e-c7e4578dbd3f.png</url>
      <title>DEV Community: Rayan</title>
      <link>https://dev.to/fichasync</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/fichasync"/>
    <language>en</language>
    <item>
      <title>Why Shopify CSV Imports Fail Silently on Supplier Spreadsheets (and a Zero-Dependency Validator to Catch Them)</title>
      <dc:creator>Rayan</dc:creator>
      <pubDate>Sat, 21 Nov 2026 19:07:20 +0000</pubDate>
      <link>https://dev.to/fichasync/why-shopify-csv-imports-fail-silently-on-supplier-spreadsheets-and-a-zero-dependency-validator-to-17kh</link>
      <guid>https://dev.to/fichasync/why-shopify-csv-imports-fail-silently-on-supplier-spreadsheets-and-a-zero-dependency-validator-to-17kh</guid>
      <description>&lt;p&gt;If you've ever built or maintained a Shopify, WooCommerce, or PrestaShop store for a client using distributor price lists, you know the pain isn't clicking &lt;strong&gt;Import&lt;/strong&gt;—it's what happens right after:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Duplicate &lt;code&gt;Variant SKU&lt;/code&gt; rows silently overwriting existing products&lt;/li&gt;
&lt;li&gt;European comma decimals (&lt;code&gt;18,50&lt;/code&gt;) or &lt;code&gt;"TBD"&lt;/code&gt; / &lt;code&gt;"Call for price"&lt;/code&gt; strings breaking price parsing&lt;/li&gt;
&lt;li&gt;Excel stripping UTF-8 characters into mojibake (&lt;code&gt;Ã©&lt;/code&gt;)&lt;/li&gt;
&lt;li&gt;Trailing spaces in headers like &lt;code&gt;"Variant Inventory Qty "&lt;/code&gt; causing Shopify to reject the whole file&lt;/li&gt;
&lt;li&gt;Case vs. unit pricing traps (&lt;code&gt;box of 12&lt;/code&gt;, &lt;code&gt;100pcs/box&lt;/code&gt;) slipping straight into live store margins&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  A Quick Zero-Dependency CLI Check
&lt;/h2&gt;

&lt;p&gt;I open-sourced a lightweight Node.js CLI validator (&lt;code&gt;0&lt;/code&gt; dependencies) you can run locally or in CI before touching Shopify Admin:&lt;/p&gt;

&lt;p&gt;👉 &lt;strong&gt;GitHub:&lt;/strong&gt; &lt;a href="https://github.com/rayantabara/shopify-csv-validator" rel="noopener noreferrer"&gt;github.com/rayantabara/shopify-csv-validator&lt;/a&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;git clone https://github.com/rayantabara/shopify-csv-validator.git
&lt;span class="nb"&gt;cd&lt;/span&gt; shopify-csv-validator
node index.mjs sample-broken.csv
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;It checks required Shopify headers (&lt;code&gt;Handle&lt;/code&gt;, &lt;code&gt;Title&lt;/code&gt;, &lt;code&gt;Variant SKU&lt;/code&gt;, &lt;code&gt;Variant Price&lt;/code&gt;), duplicate SKUs, non-numeric prices, comma decimals, broken UTF-8, and pack/case pricing phrases—exiting with code &lt;code&gt;1&lt;/code&gt; if anything needs fixing.&lt;/p&gt;

&lt;h2&gt;
  
  
  Prefer a Browser UI (or Dealing with Supplier PDFs)?
&lt;/h2&gt;

&lt;p&gt;If your vendor only sent a 40-page PDF price list or a multi-tab &lt;code&gt;.xlsx&lt;/code&gt; file (or you don't want to clone a repo):&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Free Unlimited Browser CSV Validator (up to 25,000 rows, 100% client-side):&lt;/strong&gt; &lt;a href="https://fichasync.app/shopify-csv-validator" rel="noopener noreferrer"&gt;fichasync.app/shopify-csv-validator&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Full AI Normalizer + Supplier Diff:&lt;/strong&gt; &lt;a href="https://fichasync.app" rel="noopener noreferrer"&gt;fichasync.app&lt;/a&gt; turns raw supplier Excel/CSV/PDF sheets into clean Shopify, WooCommerce, or PrestaShop CSVs in ~2 minutes with deterministic &lt;strong&gt;Strict OEM SKU Lock&lt;/strong&gt; and ephemeral &lt;strong&gt;Supplier Diff&lt;/strong&gt; (compare a new tariff against your previous CSV in RAM to spot new SKUs, &lt;code&gt;%&lt;/code&gt; price changes, and dropped items).&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Would love feedback on edge cases you've hit with distributor spreadsheets!&lt;/p&gt;

</description>
      <category>shopify</category>
      <category>ecommerce</category>
      <category>javascript</category>
      <category>webdev</category>
    </item>
  </channel>
</rss>
