Upload your store database (CSV) and image files using FTP
You may upload your database (CSV) file and image files to your Yahoo store via FTP.
Important: Upon uploading these files, your store will automatically rebuild and republish. This is a full rebuild of your store, so your data file must contain all item data. Any items which existed in your store prior to uploading these files via FTP, which are not also included in the uploaded data file, will be deleted from your store.
Before you upload
- Make sure your CSV file is the most current version, and contains all item data. If an item currently exists in your store, but isn't included in the data file, it'll be deleted from your store upon uploading the CSV file.
- The CSV file, ZIP file, and all files in the ZIP file must have all-lowercase file names, and may only use alpahanumeric characters.
- The image ZIP file must be named img.zip.
- The CSV file must be named data (don't include a file extension).
- All image files must be named according to their ID (for example, "id.gif"), and must have a .gif extension, regardless of the native format of the images.
- Images can't exceed 2 MB in size, 2 million pixels in total, or 2000 pixels in width or height. Images that exceed any of these maximum values won't upload.
- ALWAYS upload the img.zip file first, followed by the data file.
- When you upload these files, your store will automatically rebuild and republish. Please see the important note regarding rebuilding at the beginning of this article. The rebuild and republish may take some time, depending on the amount of uploaded data.
- The store software will check the FTP account every 20 minutes, and will rebuild the store with the new database.
Beginning April 8, 2014, you'll need to connect to the FTP server using FTPS (FTP over SSL). Your old settings will stop working on April 23, 2014. Please update your FTP settings as shown below. Be sure to use an FTP client that supports FTPS.
- Host name: ftps.store.yahoo.com (note the "s" in "ftps")
- User name: Your Yahoo ID. This ID must have Owner, Administrator, Store Consultant, or Store Administrator access to the store. (Learn about Access Manager user roles.)
- Password: The password associated with the Yahoo ID.
- Connection type: SSL/TLS
- Encryption type: Require explicit FTP over TLS
In addition to rebuilding your store and uploading images in bulk, you may also upload files to the "Files" section of your store via FTP.
- Add all files you wish to upload to the Files area to a new .zip file named lib.zip. File names may only use alphanumeric characters.
- Upload lib.zip to the same directory as the data and img.zip files. Unlike the data upload, lib.zip won't cause the Files area to be rebuilt – existing files will be preserved.
- The lib.zip file will be extracted and your Files area populated along the same schedule as the store rebuild.
When uploading the img.zip and lib.zip files, please note that only files with a .zip file extension may be uploaded. At this time, files with a .zipx file extension aren't supported.
- The first line of the CSV defines your item types and templates. For Store Editor version 3, default settings would be:
*item-type item. item-template storetemplate. section-type item. section-template storetemplate.
This must be a single entry to the very first cell in your spreadsheet. Don't break this line up into multiple cells.
- The second line is your field headers. At minimum, this should include:
path, id, code, name, price
For more information about the basic CSV format and field definitions, please see our database files help page.
- If you wish to populate fields such as caption for your section pages, define the sections first in the CSV, above any items. Keep in mind that you'll be using these same section names later in the path field of individual items, and the Store Editor will create objects based upon those names. You'll want to be sure to use the correct IDs for your section pages when defining them explicitly. The ID will be the name of the section converted to all lowercase letters with a dash replacing non-alphanumeric characters.
"Running Shoes" => "running-shoes"
The naming system for subsections is the same; the colon will be replaced by a dash.
"Shoes:Running Shoes" => "shoes-running-shoes"
- Include a leaf field if you're defining sections. The sections should have the leaf field set to no, while individual items will have leaf set to yes. Think of your store structure as a branch, where the individual items are the end, or "leaf."
An img.zip isn't required for all uploads. If you're not creating any new items it can be omitted. However, if you're going to upload an img.zip, it should always precede the data file upload.
Icon and inset images can be added to items when performing an FTP upload. To do so, add an icon and inset field to your spreadsheet. Fill out these fields with icon-ITEMID or inset-ITEMID. For example, if you're adding an inset image to item redshoes, the field should read inset-redshoes and the image file in img.zip should be named inset-redshoes.gif.