Should that Shopify CSV field really be blank?
When preparing a product update, an empty cell can mean “clear this value” to the importer even if you meant “leave it alone.” Make that decision before uploading your file.
This distinction comes from Shopify's product CSV documentation. It is especially useful when reviewing partial catalog updates.
Example: you only meant to edit a title
Suppose a product has the vendor “Northline.” You change its title in a spreadsheet but leave the included Vendor cell empty. Before importing, decide which of these outcomes you want:
| Your intention | What to review in the file |
|---|---|
| Keep the existing vendor | Restore its intended value, or assess whether the entire optional Vendor column should be omitted. |
| Change the vendor | Enter the intended replacement for the relevant product. |
| Clear the vendor | Confirm that the blank is deliberate and check the import preview. |
Removing a column affects every product in that import. Do not remove it if another product needs a value updated through that column.
Why not remove every column containing a blank?
A column can contain intentional values for some products and blanks for others. Product CSVs also include continuation rows for variants and images, where some blanks are expected. Review the full product group and the role of the column before editing it.
What Catalog Guard adds to the review
The checker flags selected blank product fields in update mode and includes the product, column, CSV line, and suggested next step. Adding your untouched original export also makes selected before-and-after comparisons possible. The sample report shows how findings become a prioritized action plan.
What the minimal-update CSV does
When eligible, Catalog Guard offers a CSV that removes recognized optional columns only when they are blank in every row. It preserves retained values and row order. It does not fill empty cells, invent replacement values, or resolve every finding. If you intended to clear a field, removing its column could conflict with that intention; review the original file instead.
How to review images
Do not judge an image cell in isolation. Look at all rows for the product and compare them with the original export. A blank continuation cell may be expected, while an entire product group losing its image URLs deserves investigation. The checker cannot tell you whether a remote image URL is still accessible.
Use the pre-import checklist for a broader review, or follow the two-file comparison workflow.