# Bulk Sale Price via Upload File **URL:** \ **Category:** Selling on Amazon\ **Tags:** uploads, sale-price\ **Created:** [November 19, 2024, 11:05pm UTC](https://sellersasksellers.com/t/bulk-sale-price-via-upload-file/5091 "2024-11-19T23:05:47Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![andydob](https://sellersasksellers.com/letter_avatar_proxy/v4/letter/a/ebca7d/32.png) [@andydob](https://sellersasksellers.com/u/andydob)\ **Post date:** [November 19, 2024, 11:05pm UTC](https://sellersasksellers.com/t/bulk-sale-price-via-upload-file/5091/1 "2024-11-19T23:05:47Z")
Hello, I’m trying to do a bulk upload of sale prices for our holiday sale starting Nov 21. I want to update the Sale Price, Sale Start Date and Sale End Date. I know how to do this manually (one by one), but we will have a few hundred ASINs at 25% off starting on the 21st. Doing a bit of research I’m going to: - Catalogue - Add products via upload - Download Spreadsheet - Get other Templates - Category-specific Inventory Files Here is where I become lost and don’t see where to download a file. Can anyone point me in the right direction? ---
**Author:** ![Dogtamer](https://sellersasksellers.com/user_avatar/sellersasksellers.com/dogtamer/32/4766_2.png) [@Dogtamer](https://sellersasksellers.com/u/Dogtamer)\ **Post date:** [November 20, 2024, 12:05am UTC](https://sellersasksellers.com/t/bulk-sale-price-via-upload-file/5091/2 "2024-11-20T00:05:01Z")
May I ask if the latest version of the Price & Quantity Template available on the “Download spreadsheet” ‘tab’ of the APvu (“Add Products via Upload”) Dashboard offers these options? ---
**Author:** ![andydob](https://sellersasksellers.com/letter_avatar_proxy/v4/letter/a/ebca7d/32.png) [@andydob](https://sellersasksellers.com/u/andydob)\ **Post date:** [November 20, 2024, 12:29am UTC](https://sellersasksellers.com/t/bulk-sale-price-via-upload-file/5091/3 "2024-11-20T00:29:50Z")
Unfortunately the latest Price & Quantity Template has just the following columns: sku price minimum-seller-allowed-price maximum-seller-allowed-price quantity handling-time fulfillment-channel I know this template well and have used it plenty of times before. I can use this to lower the prices to our sale prices. But it won’t be the same. I want to utilize the ‘sale price’ so we get the the strikethrough and the customer knows the product is on sale. ---
**Author:** ![oneida\_books](https://sellersasksellers.com/user_avatar/sellersasksellers.com/oneida_books/32/44_2.png) [@oneida\_books](https://sellersasksellers.com/u/oneida_books)\ **Post date:** [November 20, 2024, 1:39am UTC](https://sellersasksellers.com/t/bulk-sale-price-via-upload-file/5091/4 "2024-11-20T01:39:30Z")
Wow … what a MESS they’ve made here! Changes all around are leaving me searching too! ~~[Add Product Via Upload](https://sellercentral.amazon.com/listing/cards) \> ~~ Here’s the link to the Template download page - [https://sellercentral.amazon.com/help/hub/reference/1641](https://sellercentral.amazon.com/help/hub/reference/1641) ETA - Page Feedback I just left … ![image](https://sellersasksellers.com/uploads/default/original/2X/0/0b6d6c2440fe25de21fefe92a7a57cc78937492c.png) ---
**Author:** ![Lost\_My\_Marbles](https://sellersasksellers.com/user_avatar/sellersasksellers.com/lost_my_marbles/32/2919_2.png) [@Lost\_My\_Marbles](https://sellersasksellers.com/u/Lost_My_Marbles)\ **Post date:** [November 20, 2024, 2:05am UTC](https://sellersasksellers.com/t/bulk-sale-price-via-upload-file/5091/5 "2024-11-20T02:05:55Z")
You might start with a [Category Listing Report](https://test.sellersasksellers.com/t/how-to-get-category-listing-report/3761?u=lost_my_marbles). The link is instructions on how to get one if it doesn’t show up as in @Sundance 's reply on the linked post here on SAS. That will give you a file to start with all of your items and should (might?) have the attribute fields to complete the setting up the sales with an excel file. If it doesn’t have the attribute fields for setting up a sale, then you will also need to download a category file ( [Download Product Spreadsheet](https://sellercentral.amazon.com/listing/cards/add-product) ) to copy you items (from the Category Listing Report) into and then complete the sale attributes. Here are the Data Definitions for the attributes you will be looking for on the excel file … ![Screenshot 2024-11-19 20-04-34](https://sellersasksellers.com/uploads/default/original/2X/b/baf8c7f4a2608a03196670aab6385e67fc7f5e7d.png) Amazon has made several changes to the excel file uploads in the past year or two so finding the excel template with the right attributes isn’t as easy as it use to be. ---
**Author:** ![Lost\_My\_Marbles](https://sellersasksellers.com/user_avatar/sellersasksellers.com/lost_my_marbles/32/2919_2.png) [@Lost\_My\_Marbles](https://sellersasksellers.com/u/Lost_My_Marbles)\ **Post date:** [November 20, 2024, 2:07am UTC](https://sellersasksellers.com/t/bulk-sale-price-via-upload-file/5091/6 "2024-11-20T02:07:56Z")
> [@oneida\_books](#): > > Wow … what a MESS they’ve made here! If we weren’t already bald, we would be pulling our hair out … 😏 ---
**Author:** ![Rand](https://sellersasksellers.com/user_avatar/sellersasksellers.com/rand/32/6805_2.png) [@Rand](https://sellersasksellers.com/u/Rand)\ **Post date:** [November 20, 2024, 3:58pm UTC](https://sellersasksellers.com/t/bulk-sale-price-via-upload-file/5091/7 "2024-11-20T15:58:10Z")
Just figured I’d add this - don’t forget to set your end date for the sale a day after you actually want it to end Not affiliated with anyone with this link, had it bookmarked: [https://vocationalmedia.com/blog/sale-price-vs-coupon-end-dates-on-seller-central-a-bit-inconsistent/](https://vocationalmedia.com/blog/sale-price-vs-coupon-end-dates-on-seller-central-a-bit-inconsistent/)