Yahoo Store Help
- Does your system support legacy Yahoo stores?
Yes, we fully support legacy stores. Just supply the objinfo.xml URL and leave the catalog.xml field blank when you set up your feed. Our system even supports a workaround so that you can create custom attributes for your legacy store.
- Yahoo Store product name/title contains path/category prefix
You need to turn off the compound-name variable in your Yahoo Store's Store Properties.
- Log into your Yahoo Store Manager and go to Store Editor
- Click Contents in the tool bar
- Click Variables in the tool bar
- Expand the Store Properties section
- Set Compound-name to No
- Click the Update button and then publish your store
- How do I bulk delete items via the Yahoo Store Catalog Manager?
If you do not have that many items to delete, you can delete them from Catalog Manager directly. See How do I delete an item in Catalog Manager?.
Otherwise, download your catalog CSV file from Yahoo, then change the Path of the items you want to delete to a path like 'TODELETE'. Then, upload the file and commit. Now, you can just navigate to the 'TODELETE' section in the Store Editor, and delete it. All the items in that section will also be deleted. See Uploading and Downloading Items via Catalog Manager for more information.
See this page for more information on deleting sections and all the items in them: Deleting a Page in the Store Editor.
For additional support on this topic, please contact Yahoo Store Merchant Support directly.
- Aabaco (Yahoo) Store Design and RTML Development Companies
We specialize in data feeds, so we do not offer Aabaco Store design services or RTML template development.
We have had clients who have worked with the companies listed below. We do not endorse any of these companies, but provide this list for your reference only.
- FastPivot - a high-end Yahoo Store design company
- 1Choice4YourStore - a medium-budget Yahoo Store developer
- YTimes - advanced RTML development for Yahoo Store
- Nakamoa - Yahoo Store RTML and add-ons
You can also consult the Aabaco Merchant Solutions Developer Network website, which has a listing of many design companies.
If you require Magento store development services, consider these providers:
- Product Data Entry and Amazon Listing Service Providers
If you need help adding product listings or product data to your website or onto Ebay, Amazon, Alibaba, etc., then consider the following providers:
- Wrong number of fields detected (x instead y)
Your Yahoo Store might give you a message that says, "WARNING: Wrong number of fields detected(6 instead 7)" when you upload a CSV file from Excel into your Yahoo Store Editor or Catalog Manager via Database Upload.
This is an Excel problem. Sometimes, Excel does not put trailing commas if the last few fields in a row are blank. In that case, Yahoo thinks the field is missing. As a workaround, just rearrange the columns so that a column with full data is the right-most column. For example, you can just move the 'id' column to the end.
An example is below.
Tue May 1 10:40:10 2011 Database upload default-table Uploaded Field names=(:ID :MANUFACTURER-PART-NUMBER :BRAND :GOOGLE-PRODUCT-TYPE :UPC :NAME :MANUFACTURER) 600 records are loaded for add. Warnings and Errors Record Detail 16 [Show] WARNING: Wrong number of fields detected(6 instead 7) 17 [Show] WARNING: Wrong number of fields detected(6 instead 7) 18 [Show] WARNING: Wrong number of fields detected(6 instead 7) 19 [Show] WARNING: Wrong number of fields detected(6 instead 7) 20 [Show] WARNING: Wrong number of fields detected(6 instead 7)
- "Enabled, but do not syndicate" option in Yahoo Store
Under Promote > Search Engines in your Yahoo Store Manager, you will find links to two store export files, objinfo.xml and objinfo.xml, that contain all the data in your store catalog. (Legacy stores only have objinfo.xml.) Each store export file has three settings, Enabled, Enabled, but do not syndicate, and Disabled. This article explains the definition of each option.
- This means the store export files will not be available for download from your store. If someone tries to access the URLs, the server will return an error.
- This means the store export files will be available for download by anyone from your Yahoo Store. Furthermore, Yahoo will submit an automatic data feed to their partner search engine, PriceGrabber. (You would still need a paid PriceGrabber account to actually receive clicks.) We are not aware of them submitting to any other search engine automatically.
- Enabled, but do not syndicate
- This also means the store export files will be available for download by anyone from your Yahoo Store. However, Yahoo will not automatically submit the files to PriceGrabber.
We recommend our customers to use the Enabled, but do not syndicate setting because the automatic feed from Yahoo to Pricegrabber interferes with the PriceGrabber data feed submitted from our system. Yahoo's automatic feed to Pricegrabber is generally not reliable or customizable, so many merchants prefer to use our data feed service to submit to them.
- How do I add custom fields to my Yahoo Store?
You can easily add custom fields to your Yahoo Store catalog in order populate item-specific values. Check out the excellent video by 1choice4yourstore, Yahoo Store Database Uploads Video Tutorial, for a helpful overview. You can also refer to the Adding, editing, and removing attributes from tables instructions and contact Yahoo Store technical support for further assistance.
How to Add a Custom Attribute
- Log into your Yahoo Store Manager
- Go to Catalog Manager > Products tab > Manage Tables
- Select your product table using the Manage table drop-down menu.
- Click the Add New Attributes link to the far right of the the Custom Attributes heading.
- In the Add New Attribute dialog box, enter the following:
- Attribute Name:
- Format: text
- Leave the Required checkbox unchecked.
- Leave the Default Value field blank.
- Leave the Description field blank.
- Attribute Name:
- Click Add
- If you get an error like, 2000 : Invalid attribute name. 'upc' is a reserved attribute name, then click the Add New Attributes link to the far right of the the Shopping Attributes heading instead. You will be able to check the fields you want to add. Generally, do not make them required and do not enter any default value.
Suggested Fields to Add
The fields below can be added as 'Shopping Fields' to the table in Yahoo Store Catalog Manager. The fields in bold are pre-configured in our Google feeds.
We recommend adding the following custom fields in the 'Custom Fields' section of the table, when applicable:
Populating the Fields
After adding the custom fields, use the Yahoo links below for instructions on how populate the data using Excel or OpenOffice Calc.
- Power Tips for Yahoo Store Merchants
Videos on how to use Catalog Manager
They say a picture is worth a 1,000 words, so certainly, a video could be worth 10,000. Our friends over at 1Choice4YourStore have put together some awesome Yahoo Store Help Videos on how to make the most of the Database Upload feature of the Yahoo Store Catalog Manager. Spend a couple hours watching these videos and it could save you days of tedious work in the Store Editor!
iMacros Add-on for Firefox
You can automate your busy-work with the iMacros Add-on for Firefox. After installing it, press F8 to see sample macros and play/record buttons in a side-bar. Then, click Record to record your actions. When you're done recording, click the Play button to play back your actions. It will save you a lot of time on some repetitious tasks!. For example, you can set up automatic addition of property fields to Yahoo Legacy store items.
Tip: To work with the Yahoo Store Editor, switch the mode from 'html tag' to 'x/y' before recording. After recording your actions, delete the GOTO URL line and then replace the form and attr lines with the '*' symbol. You may have to create multiple macros depending on the position of the buttons on various types of pages, e.g. pages with multiple products per page vs. pages with a single item.
- Legacy Yahoo Store RTML Template to Export Custom Attributes as CSV
To support legacy stores, we can now install a special template in your Yahoo Store that can export your custom item attributes or properties, such as UPC, brand/manufacturer, and manufacturer part number (MPN). The template exports the data in CSV/Excel format, which is picked up by our system whenever a data feed is generated. The data can be mapped to any data feed attributes with a Custom Feed. The template installation costs $99. Please follow the instructions below to get started.
- Log into your Yahoo Store Manager, and click the Access link under the Site Settings section, (found on the right-most column of the page.)
- Give Store Editor access to .
- Submit a request using this link: Request Legacy Yahoo Store RTML Installation - $99.00
- Send us an email with the names of the custom attributes that you want exported.
The attributes to add are listed below. If you do not use an attribute or the value is always the same, then there is no need to add it.
brand (required) mpn (required) upc (required - leave blank if not available) google-product-category (if other than default value defined in feed) google-condition (can be 'new', 'used', or 'refurbished' only) google-availability size, color, gender, age-group (see apparel requirements) uc-category (optional, for Unbound Commerce) pg-category (optional, for Pricegrabber)
Objects and Types in Yahoo Store Editor
When you create an item, it is assigned a "type" by the Yahoo Store. The "type" defines the properties of the item, such as name, caption, UPC, brand, etc.
The Yahoo Store comes with a number of built-in types with standard properties. You are not able to add properties to the built-in types, so it is better to create a custom type based on the built-in type. If you have not already, we recommend that you copy the "item." type to create a new custom type called "c-item".
On the "c-item" type, you can add properties, and these will be applied to all items based on that type. If your items are based on the default "item." type, then to add properties, you must add them to each item individually. You can do that quickly by using the iMacros add-on for Firefox, or use an automatic Yahoo Store property addition service.
You can not delete or rename properties added to a custom type, so add these carefully. It is not possible to change the 'type' of an item after it has been added. The item must be saved offline, deleted, and then added back.
In the "Config" section of your Store Editor, you can set the default "type" for new items to the "c-item" type that you created.
Set up your "c-item" type with the properties required by the search engines, like "upc", "mpn", "brand", "google-condition", etc. Refer to the list of suggested fields to add for a complete list.
Our template will be able to export the properties assigned to your items, whether they were added via a property override or via the "type", as long as they are named consistently in each item.
If the data you are adding to your store does not appear in your data feed, then you may need to use this workaround. Use the Yahoo Store Editor 'Find' button to look for the 'aten-software-feed' item, click 'Edit' for it, and then click 'Update'. Once you do that, you can publish as usual. This will ensure that the Yahoo Store updates that page, and that our system is able to retrieve all the latest data.
- How do I add custom fields to a legacy Yahoo store?
Please see here for a new, easier alternative to the method described below:
Legacy Yahoo Store RTML Template to Export Custom Attributes as CSV or Excel
Legacy Yahoo stores do not support the catalog.xml Store Export file that would contain extended product attributes. We can map 'manufacturer-part-number' (MPN) to your Yahoo Product ID or Code field if that works. For 'brand', we can set the default value equal to your store name if it applies to all your products. Otherwise, you can embed product-specific values for these attributes in your product captions or descriptions as follows:
<!-- <brand>Performance Golf</brand> <upc>012345678912</upc> <mpn>100XYZ</mpn> <gpcategory>Sporting Goods > Indoor Games > Bowling > Bowling Gloves</gpcategory> -->
The fields shown above are the recommended minimum, but you can add or remove fields as needed. For example, if your MPNs are in your Code field, brand is your store name, and product type is the same for all products, then you can add the UPC as follows:
<!-- <upc>012345678912</upc> -->
For any products with no tags, or with missing values in the tags, our system will just leave the value blank in the feed. Therefore, you can add data over time and it will be automatically picked up in the feed as it is made available.
The information in the made-up HTML tags is commented out and will not be visible in your actual product pages, but you could use style sheets and display the information too. After you populate the data in your descriptions, you must contact us and we can set up your feed to extract the data.
Your feed will have to be upgraded to a Custom feed to support this technique.
For best results, we recommend adding a category field for each shopping engine. We can configure each feed to use the appropriate data. For the other fields like <manufacturer> and <mpn>, we can use the same data for every feed, so you do not need to make a different one for each shopping engine.
Not all the items need to have the embedded attribute values. We can define default values for those items with a value missing.
If product attributes are already in your descriptions in a consistent, standardized format, we can usually write custom fields to extract the existing attribute values.
Click the following link for more information on configuring brand, MPN, and UPC.
Below is a more extensive example of the attributes you can provide using this technique. The tags are listed in order by our estimation of importance to Google.
<!-- <brand>Performance Golf</brand> <upc>0123456789</upc> <mpn>100XYZ</mpn> <gpcategory>Sporting Goods > Indoor Games > Bowling > Bowling Gloves</gpcategory> <googleshipping>US:::0.00</googleshipping> <googletax>US:CA:8.25:y</googletax> <agegroup>adult</agegroup> <gender>unisex</gender> <color>white</color> <size>Small</size> <material>leather</material> <pattern>solid</pattern> -->
- Yahoo Store Corrupt Caption in objinfo.xml Store Export
Yahoo Store has an known bug where the 'caption' field in the objinfo.xml store export file is occasionally corrupted. The captions are truncated and mismatched after a certain point in the file, resulting in wrong product descriptions for most of the products.
Our system uses the captions from the catalog.xml, if available, which are not corrupted. Unfortunately, for legacy stores, our system relies on the captions in the objinfo.xml, and this therefore causes data feed corruption. The corruption occurs rather infrequently.
We have been contacting Yahoo regarding this for many months with no resolution. We have implemented retry logic to attempt to detect the corruption, but it is not 100% reliable.
We have an open support ticket Yahoo tech support and they say they are working on a fix.
- How do I find an item by ID in my Yahoo Store?
- Log into your Yahoo Store.
- Go to the Store Editor.
- Click red arrow on the far right on the Store Editor Toolbar to switch it to Advanced mode.
- Click the Controls button in the Store Editor Toolbar.
- Under Store Editor Setting, change the Show Find Button setting to Yes.
- Click Update.
You will now have a Find button on your Store Editor Toolbar that will let you find items by typing in their product ID. This is helpful for quickly finding specific items, such as discontinued items or items with missing information.
Other Yahoo Store Editor Search Methods
You can also find the item by looking through the Contents, but this can be time-consuming.
On the Controls page, there is also a Search function that allows you to search your entire store by Code, Name, Caption, Abstract, Contents, Headline, or Ship-weight. The search option can be 'exact match', 'is empty', 'is non-empty', or 'contains'. For details, refer to the Yahoo Store Editor Variables Guide.
- Error images (all red square images) in Yahoo Store feeds
Occasionally, you may find some of the images in our feeds look like a small, all-red square, with image URL http://store1.yimg.com/Img/error-img.gif. The Yahoo Store error image is displayed below:
This occurs when the image is too large. Although the store editor and store will show the image correctly, the error image will show in the store XML exports.
To resolve the issue, re-upload the image for the item into your Yahoo Store via the Yahoo Store Editor, and re-publish. The image must meet all of these requirements:
- Height is less than or equal to 2,000 pixels
- Width is less than or equal to 2,000 pixels
- Total pixels (Height * Width) is less than or equal to 2,000,000 pixels (Note: A 2,000 * 2,000 image is 4,000,000 total pixels, which exceeds this limit.)
- The image file size must be less than 2 Megabytes
Go to Manage Feed > Validation Report to find all the error images in your feed.
Alternatively, download your feed file and open it in Excel. Then sort by the image URL column and look for any images with the above error-img.gif URL.
- Can I include external inventory data into my data feed?
Some Yahoo Stores track their inventory or stock status in an external database, which stores the product code/ID and inventory count for each product. For these stores, we have the capability to read that data and include it in your data feed. This allows you to set the quantity attribute with accurate data, or set the availability attribute to out of stock. Typically, we just add a filter to remove the out of stock items from the feed, i.e. where quantity on hand is zero or less.
We can integrate with the following inventory tracking systems:
- Yahoo Store Database Inventory
- Centrifuge Inventory System by KingWebmaster
- Your supplier's inventory file
- MySQL database
This feature requires a Custom data feed. Please let us know where your inventory database is located, and we can give you a quote for the setup.
The inventory is fetched every time your feed is refreshed or resubmitted, ensuring accurate stock data. We can set up your feed to run more frequently than once per day if desired, or to a customized schedule.
Note: Non-orderable and zero-priced items are not imported into our system, so there is no need to filter those items.
- How to grant access to your Yahoo Store Catalog API
- Log into Yahoo Small Business: My Services as an Admin
- Click on Store to go to your Store Manager
- Click Real-Time Links
- Click API Settings
- Click the Add New Partner button
- Enter this Partner ID:
- Check the box for Catalog API
- Click the Next button
- Click the Accept button
Yahoo Store will send us an automated email with the API token.
The API access has to be manually renewed when it expires.
- Do you have code/specifications to create the Yahoo Store Export file?
Use the information below to generate a Yahoo Store export file in XML format from your product database. This XML file can be plugged directly into our system.
There are two Yahoo store product export files:
Here is an important note from the objinfo.xml files:
"Note that although the native encoding of this store's content is iso-8859-1, all the text in this XML export format has been converted to UTF-8"
We suggest sticking to UTF-8; our system uses that too.
You should set the published date in the XML tag:
and also in the 'Last-Modified' header of the HTTP request. (Our system uses the latter for caching purposes.) If it is not easy to calculate the timestamp, just set it to the current time. All the other elements in the settings section are not needed for our system.
Here are the links to the XML Document Type Definitions (DTD):
You do not need to implement every possible field. Our system will work even if just the main ones are implemented, like title, url, image, price, and description. Path is a bit tricky, and can be left out. The catalog.xml file is entirely optional, but should be implemented in order to get all the attributes into Google and maintain ranking.
Sample code to add the 'Last Modified' HTTP header is below.
$lastModified = time(); // OR SOMETHING LIKE $lastModified = "SELECT MAX(DateModified) FROM Product"; $gmdate_mod = gmdate('D, d M Y H:i:s', $lastModified) . ' GMT'; $expiresDate = gmdate('D, d M Y H:i:s', time() + 3600) . ' GMT'; header("Expires: $expiresDate"); header("Last-Modified: $gmdate_mod"); header("Cache-Control: max-age=3600, private");
Note that in the objinfo.xml file, 'Description' is actually the title, and 'Caption' is actually the long description.
We recommend to flush output as it is generated. Our system has a built-in timeout if a page does not respond for a long time, so the script might not work for a larger store unless it sends the data continuously rather than buffering it before sending it. Your script might also run into memory limits if it is being buffered.
- What is the 'Daily Plus' Update Frequency option?
The ‘Daily Plus’ Update Frequency option is a feed setting that automatically uploads your latest product listings to the shopping engine within a short time (about 1 hr) of your Yahoo Store being published. It submits your feed a minimum of once per day, even if you do not publish your store.
This free feature enables you to meet Google's new high-quality data requirements and provide an excellent shopping experience to your shoppers. Shopping.com also recently announced a capability to accept more frequent data feed submissions.
- Log into My Account
- Click Manage for your Google feed
- Click Modify Settings
- Select the Daily Plus Update Frequency
- Click the Update button to save your settings
Your feed will be submitted a minimum of once per day even if you do not make any changes in your Yahoo Store.
This option is currently only available for Yahoo Stores. It is also restricted to shopping engines that prefer/allow multiple updates per day, namely, Google Shopping and Shopping.com. Feeds will not be submitted if you have no credit balance, or if there are outstanding tasks for the feed.
Your feed will be automatically resubmitted (within about 1 hr) after you change field definitions on the Define Fields page for your feed. If you are testing changes, make sure to set your feed's update frequency to Never to temporarily pause the submissions.
We recommend enabling this option for all feeds, unless your product listings change independently of your Yahoo Store Publish function. For instance, this may occur if you have an external inventory status database. Contact us if you need scheduled submissions more often than Daily, e.g. every four hours.
As per our terms of service, submissions are made on a best effort basis, and no guarantee or warranty is made as to timeliness of submissions.
- Catalog Field Instructions for Yahoo Store Options
Catalog fields can output the first option value or all option values (comma-separated) into the feed. This is supported for Yahoo Stores only at this time.
First Option Value
Example Field Name:
To output the first value from a specified option, enter the value displayed above into the Field Name setting. Replace the word
Colorwith the exact name of the desired option. The name is case-sensitive. In this example, if you have an option named "Color" with values "Red", "Green", and "Blue", the value "Red" would be returned.
All Option Values for a Single Option
Example Field Name:
To output all the values of the specified option, enter the value displayed above into the Field Name setting. Replace the word
Sizewith the exact name of the desired option. The name is case-sensitive.
Values will be comma-separated. For Google feeds and Custom feeds, commas will be stripped if there are more than 10 values.
- Can I backup, download, or export all my Yahoo store images?
Please use the following instructions to download, backup, or export all your Yahoo Store images to your computer.
First, configure one of your data feeds, preferably your Google Shopping feed.
- Go to My Account
- Click Manage for your Google Shopping feed to get to the Manage Feed page.
- Click Advanced Settings
- Set Image Hosting to Enabled.
- Wait about 10-15 minutes for your image hosting data to be loaded.
Next, prepare a folder and download the images.
- Create a new folder on your computer, e.g.
- Open the URL –
– in your web browser. Replace
12345with your FeedId, which can be found in your browser's address bar when you click on the Manage Feed page.
- Use your browser's File > Save As function to save the file as
download-images.batto your images folder.
- Download wget.exe and save this file also in the images folder. This program is a free download tool for Windows.
- Double-click the
download-images.batfile, and the images will begin downloading.
- If you receive a security warning, just click Run.
- When you are done downloading the images, go back to Manage Feed > Advanced Settings, and set Image Hosting to Disabled.
Caveats and Notes
- This will only download the primary image for items that are marked orderable and have a non-zero price.
- If you add or remove products, you have to download and run the latest version of the
- You must be using a computer with the Windows operating system.
- The batch file and wget.exe must be in the same directory. You can also copy wget.exe to your c:\windows\command folder, to make it globally available on your computer.
- You can stop and restart the batch file, and it will pick up where it left off. It will not re-download images if they already exist and they are up to date.
- How do I define categories for Unbound Commerce feeds?
To set up your categories for UnboundCommerce mobile commerce data feeds, please use the examples below.
DESCRIPTION : SAMPLE CATEGORY Top-Level Category : Nike Shoes Category and Sub-category : Shoes > Nike Category and Sub-categories : Shoes > Nike > Slip-on Multiple Categories : Nike Shoes|Running Shoes Multiple Categories (example 2) : Brands > Nike|Types > Running
- Use the '>' greater-than character to separate category levels.
- Use the '|' pipe character to separate multiple categories.
- Keep category names short to conserve space on the mobile screen.
If you have a legacy store, you can embed the category information in an HTML comment inside the Caption field of each product. Add the code shown below to the bottom of every Caption, and change the category as appropriate.
<!-- <uc-category>Brands > Nike|Types > Running</uc-category> -->
Remember to replace the '>' greater-than character with '>' to ensure that the HTML code remains valid. For more information, see How do I add custom attributes to a legacy Yahoo store?
- Google Feed Warning: Value too long in attribute: id
Google limits the 'id' attribute to 50 characters. This took effect on September 30th, 2014.
Under Manage Feed > Google Validation Report, you will see an error for the items with 'id' over fifty characters.
This problem primarily affects Yahoo Stores. Here are various options for resolving this issue.
The best option is for us to convert your long IDs to a short, unique, hash code in your feed. We can enable this option upon request.
One option is to simply filter the items with errors out of the feed.
Firstly, truncating the IDs does not work, because it could result in duplicate IDs.
For Yahoo Stores, another solution is to use the 'code' field as the ID instead of the product ID. You can use the Manage Feed > Analyze Source Data to view an analysis of your 'code' field. If it contains no duplicates or values over 50 characters, then it can be simply configured as the field name on the Manage Feed > Define Fields > Edit 'id' page. For other store platforms, you could select another suitable field with unique, short value, like 'entity_id' or 'productcode'.
A hybrid option might be to truncate the ID and append a unique code, but then this derived ID might change over time, and that may cause problems for reporting. We do not offer this option.
A final option may be for you to change the ID of the item in your store. We may offer one or more of the other options as a temporary fix, or if you have too many items to fix.
How to Change a Yahoo Store Product ID
Yahoo provides no mechanism to allow you to change the ID of an item.
You must create a new item with the new ID, copy over the product data and images from the old item to the new item manually, and then delete the old item. At the same time, you should create 301 redirects from the old product URLs to the new product URLs. This ensures that inbound links do not get broken and you do not lose any organic ranking in search engines.
You may be able to change the IDs in a batch. First, download a CSV file of your products with long IDs from Catalog Manager. Then, change the IDs and upload the file back to create the new items. Next, download the images for the old items and save them with the ID of the new item. You can use multiple image upload to upload the images into the new item. We do not provide support for Yahoo Store, so please contact Yahoo Support for more information. You can also use the links below as a starting point:
- Currency Conversion Add-on for Yahoo Stores
Are you interested in selling your products in Google Shopping for Canada*, the UK, Switzerland, or Australia? If so, then you need the currency conversion add-on for your Yahoo Store.
The currency conversion add-on upgrades your existing Yahoo Store so it can display the product price in a foreign currency, as required by Google Shopping.
The countries listed above can accept your product listings in English, so no content translation is required! As long as you can ship the products to those countries, You can use your product catalog as-is.
To get started, follow these steps:
- Purchase the Currency Conversion Add-on from Y-Times, which starts at $200.00. Submit a request noting that you would like the Currency Conversion Add-on.
- Purchase our Feed Setup and Optimization for each country.
Y-Times is a Yahoo Store Developer who will configure your templates to support the currency conversion on your website. We will set up a product feed to the requested country.
The Y-Times currency conversion add-on dynamically sets the price on the product page to the local currency when a visitor arrives. It sets a cookie in the visitor's browser so your store continues to show the local currency as they browse your site.
Our feed calculates and submits the pricing in local currency to Google Shopping. It also updates the conversion rate on your website, thereby keeping the pricing in-sync between your website and the feed. Our system uses the latest currency conversion rate from Yahoo Finance.
Please contact us if you have any questions.
Note, if you are concerned about fraudulent international orders, consider using a fraud prevention service like Threat Metrix to screen out fraudulent orders.
*Note: Product Listing Ads for Canada only appear on google.ca, because there is currently no equivalent to Google Shopping in Canada.
- Yahoo Small Business Spinning Off; Re-platforming Advice
Lately, a lot of things have been happening around Yahoo! Small Business, and by now most, if not all of you have probably heard at least some of it. I've been getting emails and phone calls from worried merchants who, understandably, are worried and uncertain about what the future holds for their online stores. While an official communication from Yahoo is still forthcoming, I thought I'd go ahead and share with you what has been made public, what I know, and my take regarding the situation.
Starting with Yahoo! Stores (or "Yahoo Store 2.0"), you may or may not have heard that about a year ago Yahoo started building a brand new e-commerce platform. I was part of a select number of developers who worked with the new platform from the beginning, and helped develop the "themes" new Yahoo Stores customers can choose from when signing up with the new platform. This new platform has been available to the general public for some time (maybe a couple of months or so?). The new system is very different from, and not compatible with the editor-based system your store is on. Although available to the general public, the new system still has a lot of features planned but not yet done, and admittedly in its current form it is aimed at small scale stores rather than larger enterprises most of you are running.
Then, very recently came the announcement that Yahoo! Small Business is going to be spun off Yahoo! as a completely separate, independent company. This development had to do with the fact that Yahoo! is a major shareholder of Alibaba, and because of the Alibaba IPO they were going to be slapped with a big (huge) tax bill unless they could somehow get rid of a bunch of Alibaba shares. The immediate flip-side of this is that this new (yet to be named) company will be the most well funded "startup" in History. I put "startup" in quotes, because of course it is far from being a startup. The "new" company will come with a seasoned team of professionals, plus the technical background of the Yahoo! e-commerce platform. Not being part of a huge corporation such as Yahoo! may actually be an advantage in that the new company will be free to concentrate on what they know best: e-commerce. By the way, as you can imagine, the formation of the new company will not take place in a matter of days or weeks; it is going to be a process lasting most likely several months.
So where do all these developments leave you and your current Yahoo! Store? Here are the facts I know:
- The new platform is moving forward, but is not yet up to par with the current system. - The current system is not going to be shut down.
- No current Yahoo! Store will be forced to switch to the new system. Since the viability of the company depends in no small part on the existing merchants, it really means that you can continue running your business as usual, investing in new development and all, knowing that the platform you are on will not be pulled from under your business. However, I know that some of you are entertaining the idea of moving to a different platform, and others will be courted by different platforms to switch and take your business elsewhere. If you are considering re-platforming, you should keep the following in mind:
- Replatforming is expensive. Contrary to what you may hear, unless you have a cookie-cutter online store, moving it to a totally different platform will probably involve a new design (an existing "skin" can never be transferred from one platform to a different one), a brand new implementation, plus migrating your data (which, granted, some of the other platforms make it easy for you.)
- Since the new Yahoo system is not compatible with the current Yahoo store system, switching from the current (RTML-based) system to the new 2.0 system is the same as re-platforming (to a third party system.)
- It's very nearly impossible to replatform and expect your SEO to remain exactly the same.
- If your main reason to replatform is because "the other guys" said your SEO will immediately be better, it is not true. One platform is not inherently better for SEO than another. Your web site's SEO is only as good as your content.
- ... and along the same line, when you hear someone say that Yahoo Store is bad for SEO, that's not true either. This platform has more Internet Retailer Top 500 businesses than any other.
- If you want to replatform because the other platform is mobile-friendly out of the box, that's probably not entirely true either (and as a matter a fact, it is not entirely true with the new Yahoo! 2.0 platform either.) You can have a mobile-friendly "canned" template, but it will not be unique to your business. If you want a custom designed web site, there is work going into making it mobile-friendly.
- And, related to this last point, the current Yahoo! Store platform does allow mobile-friendly web sites. Email me for examples if you are interested.
- Lastly, as tempting as it may seem to cure any number of perceived ills you are experiencing by jumping to another platform, you will still be faced with needing some level of custom design, custom development and consulting services, preferably from a trusted, experienced e-commerce solutions provider, a role that Y-Times continues to fulfill.
This may be a lot to absorb especially if you haven't been up to speed on the recent Yahoo! Small business developments. Feel free to email me or call, or contact your Yahoo! account representative if you need more information.
Y-Times Publications, LLC.
February 23, 2015 Email Newsletter
- Matching Yahoo UPS Ground Shipping Rates to Google Shipping Rates
In Yahoo Store Shipping Settings, found under Store Manager > Shipping Manager > Ship Rates, it is possible to set up a UPS Ground Carrier-Calculated rate in addition to a Percentage of order total amount. The two amounts are combined to compute the final shipping charge for an order.
In Google Merchant Center Shipping Settings, it is NOT possible to set up a carrier rate and add a percent of order total to it. To solve this problem of adding multiple rates together in Google Shipping Settings, read on.
As a workaround, you can create multiple carrier rates for each order price level. For example, if you charge the UPS Ground carrier rate plus 5% of the order total, then you create the following rate:
- Rate Name: UPS Ground $0.01-$20
- Rate Type: Carrier Rate
- Service: UPS Ground
- Fixed Markup: $1.00
The above rate would be assigned in the Shipping Rate Table by Order Price to order price levels from $0.01 to $20.00. Five percent of $20.00 is $1.00, so that upcharge covers all order prices from $0.01 to $20.00.
Note that Google requires the shipping rates to be higher than or equal to the actual rate charge by your store.
You would continue adding rates like this up through your highest product amount. The next one might look like this:
- Rate Name: UPS Ground $20.01-$40
- Rate Type: Carrier Rate
- Service: UPS Ground
- Fixed Markup: $2.00 (five percent of $40)
Here is a screen shot showing a sample of how it would look:
UPS Ground Carrier Rate Plus Percent of Order Total in Google Shipping Settings
The more price levels you add, the more accurate your rates will be, but it will take more time to set up.
- Download inventory and upload it to ftp.atensoftware.com on iPad/iOS
Install and Configure FE File Explorer App
- Install FE File Explorer free version (not Pro)
- Press '+' to add a new connection
- Choose FTP
- Enter the following settings:
Display Name: leave blank
Host Name/IP: ftp.atensoftware.com
Port: leave blank
Path: leave blank
Protocol: Require explicit FTP over TLS
Transfer mode: Passive
User Name: as provided to you
Password: as provided to you
- Press ftp.atensoftware.com under Connections
- You should see the list of files in the folder, or no files
Download inv.csv file
Note 1: If the inv file already exists in the Files app on your iPad, be sure to delete it first before following the steps below. Otherwise, the file will be downloaded as inv 2 and won't be recognized by our system unless it is renamed to inv
Note 2: iOS will not display the .csv file extension, but it will be there in the background. You can verify this by selecting Info after selecting the file in the Files app.
- Login to Yahoo Small Business
- Go to your Store Control Panel
- Click on Process > Inventory
- Click the Download button
- Choose All Tables and click the Download button
- Click Download when prompted Do you want to download "inv.csv"?
Upload inventory CSV file
- Launch the FE File Explorer app on your iPad
- Select FE File Explorer (Cloud) from the side-bar
- Select the Files App folder
- Select inv file that was downloaded earlier
- Select Copy to
- Select ftp.atensoftware.com under Connections in the Copy to dialog window
- Select Save
- If the Resolve conflicts dialog appears, press Replace
- All steps are completed at this point, and you can exit the app.
- If you wish to confirm the upload was successful, press ftp.atensoftware.com under Connections and verify the inv file time and size