Advanced CNShopper Spreadsheet Tips

You have mastered the basics. Your cnshopper spreadsheet tracks orders, calculates profit, and stays organized. Now it is time to upgrade from functional to powerful. These advanced tips will save hours every week, surface insights you never noticed, and make your system feel like a custom-built app.

Conditional Formatting for Status

Do not read every cell to know what needs attention. Let colors speak for you. Set up these rules in your cnshopper spreadsheet:

• Green background — "Delivered" orders.
• Yellow background — "Shipped" orders (in transit).
• Red background — "Pending" orders older than 7 days.
• Gray text — Cancelled or refunded orders (dimmed but retained).

Pivot Tables for Category Analysis

Pivot tables turn raw rows into actionable summaries. Create one that shows total profit by product category. You might discover that shoes earn 40% more margin than hoodies, which reshapes your buying strategy for next quarter.

Google Apps Script Automation

Apps Script lets your spreadsheet send you an email whenever an order status changes to "Delivered." No more manually checking tracking sites. The script runs in the background, reads your sheet, and triggers actions based on rules you define.

Data Validation for Error Prevention

Prevent typos by restricting input types. Force the Status column to accept only values from a dropdown. Lock the Margin column so nobody accidentally overwrites your formula. These small constraints save hours of debugging later.

Import Range for Multi-Store Tracking

Running multiple storefronts? Use IMPORTRANGE to pull order data from separate sheets into one master dashboard. One spreadsheet per store, one dashboard to rule them all. This is how serious resellers scale without drowning in tabs.

FAQ