ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.
Need to verify how eBay's 'Offers' in bulk edit works
In bulk edit
select all listings
'bulk edit'--'offers'
'allow offers'
'auto accept amount' lower by %(see screen cap)
If I used '90' does that mean that all offers of 89% of my asking price will be auto-declined, and only those that are 90%, or higher of my asking price will be accepted?
I looked at this page the other day, trying to find a response to your prior question, and opened some of the info boxes on the screen. The only thing I could work out is that the settings on that screen will change your PRIOR settings by the specified percent; and that the bulk settings do not apply to your asking price. If you had not previously added limits to your original listing, then the limit changes shown in your screenshot would have no effect.
I tested with a $99 listing, where I selected the item in seller hub and used the "offer" option from the drop list in Active listings to add a "best offer" feature.
I set limits to accept 5% lower and reject 10% lower.
As shown in the screenshot, my accept= $94.05 and my decline=$89.10
Then I used the bulk editor to change the percentages again by 3%.
Thus, to spread the gap, I lowered my rejection by 3% from 89.10 to 86.427 and raised my acceptable by 3% from 94.50 to 99.871 (which I verified by going to my Active Listings grid to review the revised offer settings for that listing).
When I had initially closed the gap by raising my rejection and lowering my acceptance by 3%, I received an error because there was a fatal overlap area where both accept and decline would conflict.
So, the initial offer limits are converted to prices that are stored somewhere. Modifying a limit by a percentage, up or down, will then modified the stored prices, not the asking price.
@popch3 wrote:Or, maybe I should ask how to set up my listings so offers that are 90% or more of my asking price are accepted, and offers 89% and less are declined?
Are you trying to void your offer settings, or simply rework them?
You should be able to bulk remove all "best offer" settings by clicking "Don't allow offers".
I wonder if that will zero out your limits.
If so, then you should be able to bulk apply new limits.
I can probably test that....
@shipscriptwrote:
You should be able to bulk remove all "best offer" settings by clicking "Don't allow offers".I wonder if that will zero out your limits.
If so, then you should be able to bulk apply new limits.
I can probably test that....
You can remove all "offer" settings, and can replace with a fixed number; but can not bulk replace them by increasing or decreasing since there are no longer any limits to modify.
However, you could probably use a spreadsheet to set all of your accept and decline values using a spreadsheet formula. Then upload the spreadsheet to eBay.
I think a spreadsheet could do exactly what you want.
While the spreadsheet method would be exact, the biggest opportunity to mess up would be with auctions that don't have a BIN.
I'm going to document the process here in case someone else would like to pursue this method.
Bulk revising Best Offer using a spreadsheet
From eBay's Seller Hub Reports > Uploads page, download a template to "Edit price and quantity".
In that downloaded spreadsheet, make sure that the "Item number" column is not in scientific notation: right-click "format cells" for that column and set to "number" with zero decimal places.
Remove any rows that are variations (including each parent row), since offers are not allowed in variation listings. Remove any vacated empty rows.
Then remove the info row and all columns except:
Action, Item number, Title, Start price, Buy It Now price, and Custom label (SKU).
(the Title and SKU are just for your own info, and could also be omitted)
Next, add three new columns:
• BestOfferEnabled
• BestOfferAutoAcceptPrice
• MinimumBestOfferPrice
Now you will have a full template for changing your Best Offer.
In every row where you would like Best Offer enabled, add the value "1" for true. If you want to turn off Best Offer, then use zero, for false.
Using a spreadsheet formula, the BestOfferAutoAcceptPrice and MinimumBestOfferPrice could be calculated as a percentage of the "Start price" value in each row for Fixed Price listings or as a percentage of the "Buy It Now price" in each row for Auctions.
Below is an example of how the spreadsheet might appear, with a Best Offer auto accept value that is 90% of the Start price and a decline value that is 89% of the Start price. These are all fixed price listings. For auctions, the math would be applied to the Buy It Now price instead of the Start price:
We will see that I turned off BestOfferEnabled on a few rows where the spread was only a few pennies.
Warning: If some listings are auctions without BIN enabled, it could be possible to inadvertently use a percentage of the Start price, instead of the BIN price, to accept an offer that is too low. The seller would need to cross-correlate with a report of active auctions.
After populating the values, save as a new CSV and upload the template on the same Seller Hub Reports > Uploads screen.
When you download the template, you can remove any rows and columns that you don't want to revise. The mandatory columns are the first "Action" column and the "Item Number" (formerly "ItemID") column, and then you can add the other columns you would like to revise.
The template can have a minimum of a single row (listing) and a historical maximum of 150,000 rows.
I undertand, thank you for the reply. One more question. All of my lisitngs are Buy It Now. In the template the values are appearing in the Start price column, not the Buy it Now column.
We use Auctiva to add listings to eBay. We use only fixed price listings and enter the values in the Buy It Now field when creating the listing.
We are looking to revise our listings to auto accept offers 7% of the Buy It Now price. Will the revision take place if values are not in the Buy It Now column? Screen shot of our template is below. Thanks again for your help!
Yes, that should work. eBay receives the GTC price in the "Start price" field. The "Buy it now" is for auctions that have BIN, where the "Start price" is also used; so you can delete the BIN column if you have no auctions in your list. You can also delete those "relationship" columns if you have no variations.
