# Find which items to push, reprice or drop from your sales export

> It sorts every product into keep, push, reprice or drop, from a file you'd normally never open.

Upload a messy sales export from your POS or online store. AI tidies the data, then sorts every item into keep, push, reprice or drop, with best sellers, slow movers and busy times explained.

- Page: https://thesolocreators.com/prompts/which-items-to-push-reprice-or-drop/
- Category: Make smarter decisions
- Made for: Small business owners
- Works in: ChatGPT, Claude, Gemini
- Time: About 10 minutes
- Effort: A few steps
- Note: Remove customer names and card details first. ChatGPT for Excel and Google Sheets works on all plans.

## The prompt

Fill in the parts in [square brackets], or leave them and the AI will ask you for them.

```text
Attached is my sales export from [EXPORT SOURCE, e.g. Square, last 3 months] for [YOUR BUSINESS, e.g. a gift shop]. My rough cost for each item, if I have it: [ITEM COSTS, e.g. attached or none].

First, tidy it: fix dates, move refunds and test sales into a separate list, merge items with slightly different names, and tell me what you cleaned.

Then:
1. Rank items by sales and by units, and show my top 10 and bottom 10
2. Sort every item into Keep, Push, Reprice or Drop, with a one-line reason each
3. Show my busiest days and hours
4. Point out any items that are growing, slipping or seasonal
5. Give me three actions for this week

Use simple tables and one chart. If anything in the data looks wrong, list it first.
```

## Step by step

1. Export your sales by item as a CSV or Excel file.
2. Attach it to the chat and paste the prompt.
3. Check the list of what it cleaned up.
4. Act on the push and drop lists this week.

## What you'll get

A cleaned sales file, every item sorted into keep, push, reprice or drop, busy times and three actions.

## Good to know

**Which AI tools does this work in?** It works in ChatGPT, Claude and Gemini. On this page, ChatGPT and Claude open with your prompt already typed in. Remove customer names and card details first. ChatGPT for Excel and Google Sheets works on all plans.

**How long does it take?** About 10 minutes. It's rated "A few steps". There are 4 steps, listed above.

**What do I need before I start?** Just your details for 3 blanks: export source, your business and item costs. You can skip any, and your AI will ask for them.

**What will I get back?** A cleaned sales file, every item sorted into keep, push, reprice or drop, busy times and three actions.

Idea spotted on YouTube, shared by OpenAI: https://www.youtube.com/watch?v=sfkyiXvlYL0. The prompt is The Solo Creators' own version.

## Go further

Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Board of Advisors (Convene seven AI advisors who debate your decision, vote, and hand back a stress-tested verdict); Fact Checker (Every quote, number, date, and link in your draft checked against its real source, with the fixes handed back as tracked changes you accept or reject).

From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.