{"id":208797,"date":"2026-04-16T14:50:13","date_gmt":"2026-04-16T21:50:13","guid":{"rendered":"https:\/\/www.nationalfunding.com\/blog\/?p=208797"},"modified":"2026-04-16T14:50:13","modified_gmt":"2026-04-16T21:50:13","slug":"ai-prompts-to-help-you-maximize-revenue-on-inventory","status":"publish","type":"post","link":"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/","title":{"rendered":"AI Prompts to Help You Maximize Revenue on Inventory"},"content":{"rendered":"<p><span data-contrast=\"auto\">With the right prompts and data uploaded, AI tools like Claude and ChatGPT can help you know:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">When\u00a0you&#8217;ll\u00a0likely need\u00a0to start discounting products to make room for the next season or line.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">What inventory to avoid ordering because it never fully clears, including variations like flavors, sizes, and colors.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">How much to order vs.\u00a0guessing\u00a0when it comes to trendy products vs.\u00a0staples.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">This can save you hours of time trying to analyze data and\u00a0locate\u00a0trends.\u00a0It&#8217;s\u00a0as easy as exporting data from a few past seasons and asking for the correct output. With the right prompt,\u00a0you&#8217;ll\u00a0be able to get recommendations to help you maximize your revenue from merchandising.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">This can work for auto body shops that need to refresh refrigerants for the summer and antifreeze for winter; candy retailers that order candy canes and peppermints in winter with fruit-flavored gum and lollipops for summer; and beach town clothing stores that need hoodies for the early and end of season and flip flops in the middle. With the right modification, you can even have it help decide what to order more or\u00a0less of\u00a0to keep up with customer demand and increase your profits.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Here are prompts for each of the three scenarios above, which you can\u00a0modify\u00a0to fit your products and inventory.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Before you begin, when we reference a column with two sub-cells for your spreadsheet, it should look\u00a0similar to\u00a0this. Columns B and C equal one column for a specific\u00a0product\u00a0and there are sub-columns for the total number of products and the price per unit at that time. Week 1, 2, 3, etc. can be the dates of the week or however you track weeks in your business.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-208801\" src=\"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/Screenshot-2026-04-16-at-2.49.20-PM-300x80.png\" alt=\"\" width=\"383\" height=\"102\" srcset=\"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/Screenshot-2026-04-16-at-2.49.20-PM-300x80.png 300w, https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/Screenshot-2026-04-16-at-2.49.20-PM-360x96.png 360w, https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/Screenshot-2026-04-16-at-2.49.20-PM-768x204.png 768w, https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/Screenshot-2026-04-16-at-2.49.20-PM-1024x273.png 1024w, https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/Screenshot-2026-04-16-at-2.49.20-PM-600x160.png 600w, https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/Screenshot-2026-04-16-at-2.49.20-PM.png 1322w\" sizes=\"auto, (max-width: 383px) 100vw, 383px\" \/><\/p>\n<h2 aria-level=\"2\"><b><span data-contrast=\"none\">Scenario 1: AI Prompts to Start Clearing Products and Make Shelf Space<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">AI can help you estimate when\u00a0you&#8217;ll\u00a0need to start clearing shelf space to make room for next season&#8217;s lines, or as new inventory comes in from a pre-order. This way you can begin moving products via discounts, shifting displays to more prominent areas, or by creating bundles.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The prompt below works best for seasonality including holiday shopping, calendar seasons, and if products get a new release on a regular schedule.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The system is going to need the following in a spreadsheet or inventory report:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Inventory levels for products by month for the season and two months before (i.e.\u00a0if it is to make space for Q4 holidays, upload from August to December)<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">The SKUs that you always have and need to clear\u00a0with\u00a0the inventory levels for each of the months.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">How much each item costs per unit on average by\u00a0month\u00a0so the system knows when you begin discounting items to clear them.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">The prompt to fill out with your information:<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><i><span data-contrast=\"auto\">&#8220;Please look at the data in the attached spreadsheet where I have the months from August to December in the columns with the year for the last five years. The rows are the SKUs I sell.<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><i><span data-contrast=\"auto\">Each column has two sub-cells\u00a0below it\u00a0which represent the amount of inventory left at the end of the month and the average price per unit. In August and\u00a0September\u00a0you&#8217;ll\u00a0see the price\u00a0remains\u00a0the same as this is the peak-price season for the product.<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><i><span data-contrast=\"auto\">Afterwards I need to clear inventory so the price per unit goes down as I begin discounting. The progression in price and quantity shows how quickly I moved the product over the last five\u00a0years in\u00a0each month. It also shows when I began\u00a0discounting to\u00a0clear shelf space.<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><i><span data-contrast=\"auto\">I need to know when you would recommend beginning to discount each SKU\u00a0in\u00a0the sheet so I can clear most of the inventory by the middle of November to make room for new products. The goal is to have at least 25% less at the end of October and 50% less by the end of November as it barely moves in December.&#8221;<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">Pro-tip:<\/span><\/b><span data-contrast=\"auto\">\u00a0If you can do this by week, the output from the AI system may be even better as it can get more granular.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<h2><span data-ccp-props=\"{}\">\u00a0<\/span><b><span data-contrast=\"none\">Scenario 2: Knowing What Inventory to Avoid Ordering, or Order Less Of<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">Everyone orders a product or variant because they love it. Then each year we remember it never fully sells, so we discount, liquidate, or use it as\u00a0a free gift\u00a0with purchase. AI can help you know which products or variations to order less of, or which to avoid because they never move.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">This includes avoiding green hair ties but doubling up on black and neutral tones, or a specific type of windshield wiper fluid that never sells while ordering \u2153 more of a secondary brand which also has higher margins. This also applies to t-shirts by size, or seasonal flavors like pumpkin spice and lavender used in desserts.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">With the right modifications to the prompt below, the AI system can even help estimate your profits by including your margins by item sold to get an even better mix of how many of\u00a0each to\u00a0order.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The system is going to need the following in a spreadsheet or inventory report:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">The products and variants.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">How many are left in stock by date in either weeks or months (weeks is better) for the past 3 or 5\u00a0years.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">Optional \u2014 The price point for each if you split the in-stock number into two sub-cells for each column.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">The prompt to fill out with your information:<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><i><span data-contrast=\"auto\">&#8220;Please use the attached spreadsheet where the columns are the weeks\/months and the rows are the products with their variations. The first column for each year shows\u00a0my\u00a0total number of products ordered by SKU. The cells are how many products I have left in inventory by week\/month.<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><i><span data-contrast=\"auto\">I&#8217;d\u00a0like you to help me adjust my\u00a0ordering\u00a0so I place the right amount for the following:<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><i><span data-contrast=\"auto\">How many of each SKU should I order this year to make sure I have less than XYZ in stock by (insert week\/month here)?<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><i><span data-contrast=\"auto\">Which SKUs should I consider not ordering because they move the slowest, or how many fewer should I order to keep me with less than 20% in stock by (insert week\/month here)?<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><i><span data-contrast=\"auto\">Are there any SKUs I should consider ordering more of because they always sell out the\u00a0fastest?&#8221;<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<h2><span data-ccp-props=\"{}\">\u00a0<\/span><b><span data-contrast=\"none\">Scenario 3: When to Start Discounting<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">We all hate sacrificing\u00a0margin, but inventory needs to move. By having AI analyze when you normally begin reducing prices, you can test other ways to move products that reduce margin by 10% instead of a 20% off deal.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">It could be a bundle with complementary products, buy 2 and save 15% on the third if people normally buy two in a single purchase, or move them to a better location in your shop or ecommerce store so people are more likely to see them and add them to their cart.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The system is going to need the following in a spreadsheet or inventory report:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">The total products in stock<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">The SKUs<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">The price per product<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">The weeks or months over\u00a0a period of time<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">The prompt to fill out with your information:<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><i><span data-contrast=\"auto\">&#8220;Please use the data from the spreadsheet I uploaded that has the SKUs in the columns and the weeks with dates in the rows for the last XYZ years. In each column are two sub-cells that have the price per product and the total products in stock. My goal is to avoid discounting\u00a0products\u00a0and\u00a0you&#8217;ll\u00a0be able to see when I start by SKU because the total price per product begins\u00a0reducing.<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><i><span data-contrast=\"auto\">Please create a bulleted list for each SKU that recommends which date range I should begin trying to move each SKU more aggressively, and roughly two weeks before I would normally begin discounting.&#8221;<\/span><\/i><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">AI can help you with merchandising including knowing how many units to order, when to begin discounting or testing less costly methods of moving product, and which products you should order more or less of. Customer demand can always change, but AI can help you make an educated decision by using your past data within\u00a0seconds\u00a0so you\u00a0don&#8217;t\u00a0have to spend hours analyzing the spreadsheets yourself.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><i><span data-contrast=\"none\">National Funding\u00a0does not provide tax,\u00a0legal\u00a0or accounting advice. This material has been prepared for informational purposes only. You should consult your own tax,\u00a0legal\u00a0and accounting advisors.<\/span><\/i><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>With the right prompts and data uploaded, AI tools like Claude and ChatGPT can help you know:\u00a0 When\u00a0you&#8217;ll\u00a0likely need\u00a0to start discounting products to make room for the next season or line.\u00a0 What inventory to avoid ordering because it never fully clears, including variations like flavors, sizes, and colors.\u00a0 How much to order vs.\u00a0guessing\u00a0when it comes<a class=\"excerpt-read-more\" href=\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/\" title=\"ReadAI Prompts to Help You Maximize Revenue on Inventory\">&#8230; Read more &raquo;<\/a><\/p>\n","protected":false},"author":38,"featured_media":208798,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-208797","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-trends"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>AI Prompts to Help You Maximize Revenue on Inventory - The Bottom Line by National Funding<\/title>\n<meta name=\"description\" content=\"With the right prompt, AI can help you with merchandising to maximize your revenue by knowing when to discount or what not to order. Here are a few examples.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AI Prompts to Help You Maximize Revenue on Inventory - The Bottom Line by National Funding\" \/>\n<meta property=\"og:description\" content=\"With the right prompt, AI can help you with merchandising to maximize your revenue by knowing when to discount or what not to order. Here are a few examples.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.nationalfunding.com\/blog\/blog\/wp-json\/wp\/v2\/posts\/208797\" \/>\n<meta property=\"og:site_name\" content=\"The Bottom Line by National Funding\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/national.funding\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-16T21:50:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/AdobeStock_1952479274-ezgif.com-jpg-to-webp-converter.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Kelly Hillock\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@NationalFunding\" \/>\n<meta name=\"twitter:site\" content=\"@NationalFunding\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kelly Hillock\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/\",\"url\":\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/\",\"name\":\"AI Prompts to Help You Maximize Revenue on Inventory - The Bottom Line by National Funding\",\"isPartOf\":{\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/AdobeStock_1952479274-ezgif.com-jpg-to-webp-converter.webp\",\"datePublished\":\"2026-04-16T21:50:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/#\/schema\/person\/bc06f44d4c81138ad3f536fee0606768\"},\"description\":\"With the right prompt, AI can help you with merchandising to maximize your revenue by knowing when to discount or what not to order. Here are a few examples.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#primaryimage\",\"url\":\"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/AdobeStock_1952479274-ezgif.com-jpg-to-webp-converter.webp\",\"contentUrl\":\"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/AdobeStock_1952479274-ezgif.com-jpg-to-webp-converter.webp\",\"width\":1500,\"height\":1000,\"caption\":\"AI Prompts to Help You Maximize Revenue on Inventory\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.nationalfunding.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AI Prompts to Help You Maximize Revenue on Inventory\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/#website\",\"url\":\"https:\/\/www.nationalfunding.com\/blog\/\",\"name\":\"The Bottom Line by National Funding\",\"description\":\"Read National Funding&#039;s small business blog for tips and suggestions on how to grow your business by focusing on different aspects of business operations.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.nationalfunding.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/#\/schema\/person\/bc06f44d4c81138ad3f536fee0606768\",\"name\":\"Kelly Hillock\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.nationalfunding.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f9731694c10dd48ef5c8395aacfc3923cb3079b712f05464ba6d33a85395065b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f9731694c10dd48ef5c8395aacfc3923cb3079b712f05464ba6d33a85395065b?s=96&d=mm&r=g\",\"caption\":\"Kelly Hillock\"},\"description\":\"Kelly Hillock is the content marketing manager for National Funding, where she writes and edits articles for small business owners. Kelly has over eight years' experience in copywriting across a variety of industries, focusing on entrepreneurship and finance. She has a Bachelor of Arts in journalism from San Diego State University.\",\"url\":\"https:\/\/www.nationalfunding.com\/blog\/author\/khillocknationalfunding-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AI Prompts to Help You Maximize Revenue on Inventory - The Bottom Line by National Funding","description":"With the right prompt, AI can help you with merchandising to maximize your revenue by knowing when to discount or what not to order. Here are a few examples.\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/","og_locale":"en_US","og_type":"article","og_title":"AI Prompts to Help You Maximize Revenue on Inventory - The Bottom Line by National Funding","og_description":"With the right prompt, AI can help you with merchandising to maximize your revenue by knowing when to discount or what not to order. Here are a few examples.\u00a0","og_url":"https:\/\/www.nationalfunding.com\/blog\/blog\/wp-json\/wp\/v2\/posts\/208797","og_site_name":"The Bottom Line by National Funding","article_publisher":"https:\/\/www.facebook.com\/national.funding\/","article_published_time":"2026-04-16T21:50:13+00:00","og_image":[{"width":1500,"height":1000,"url":"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/AdobeStock_1952479274-ezgif.com-jpg-to-webp-converter.webp","type":"image\/webp"}],"author":"Kelly Hillock","twitter_card":"summary_large_image","twitter_creator":"@NationalFunding","twitter_site":"@NationalFunding","twitter_misc":{"Written by":"Kelly Hillock","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/","url":"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/","name":"AI Prompts to Help You Maximize Revenue on Inventory - The Bottom Line by National Funding","isPartOf":{"@id":"https:\/\/www.nationalfunding.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#primaryimage"},"image":{"@id":"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/AdobeStock_1952479274-ezgif.com-jpg-to-webp-converter.webp","datePublished":"2026-04-16T21:50:13+00:00","author":{"@id":"https:\/\/www.nationalfunding.com\/blog\/#\/schema\/person\/bc06f44d4c81138ad3f536fee0606768"},"description":"With the right prompt, AI can help you with merchandising to maximize your revenue by knowing when to discount or what not to order. Here are a few examples.\u00a0","breadcrumb":{"@id":"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#primaryimage","url":"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/AdobeStock_1952479274-ezgif.com-jpg-to-webp-converter.webp","contentUrl":"https:\/\/blog.nationalfunding.com\/wp-content\/uploads\/2026\/04\/AdobeStock_1952479274-ezgif.com-jpg-to-webp-converter.webp","width":1500,"height":1000,"caption":"AI Prompts to Help You Maximize Revenue on Inventory"},{"@type":"BreadcrumbList","@id":"https:\/\/www.nationalfunding.com\/blog\/ai-prompts-to-help-you-maximize-revenue-on-inventory\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.nationalfunding.com\/blog\/"},{"@type":"ListItem","position":2,"name":"AI Prompts to Help You Maximize Revenue on Inventory"}]},{"@type":"WebSite","@id":"https:\/\/www.nationalfunding.com\/blog\/#website","url":"https:\/\/www.nationalfunding.com\/blog\/","name":"The Bottom Line by National Funding","description":"Read National Funding&#039;s small business blog for tips and suggestions on how to grow your business by focusing on different aspects of business operations.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.nationalfunding.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.nationalfunding.com\/blog\/#\/schema\/person\/bc06f44d4c81138ad3f536fee0606768","name":"Kelly Hillock","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.nationalfunding.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f9731694c10dd48ef5c8395aacfc3923cb3079b712f05464ba6d33a85395065b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f9731694c10dd48ef5c8395aacfc3923cb3079b712f05464ba6d33a85395065b?s=96&d=mm&r=g","caption":"Kelly Hillock"},"description":"Kelly Hillock is the content marketing manager for National Funding, where she writes and edits articles for small business owners. Kelly has over eight years' experience in copywriting across a variety of industries, focusing on entrepreneurship and finance. She has a Bachelor of Arts in journalism from San Diego State University.","url":"https:\/\/www.nationalfunding.com\/blog\/author\/khillocknationalfunding-com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/posts\/208797","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/comments?post=208797"}],"version-history":[{"count":2,"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/posts\/208797\/revisions"}],"predecessor-version":[{"id":208805,"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/posts\/208797\/revisions\/208805"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/media\/208798"}],"wp:attachment":[{"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/media?parent=208797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/categories?post=208797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nationalfunding.com\/blog\/wp-json\/wp\/v2\/tags?post=208797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}