Can I use FTP to upload my database (CSV) file and image files?
You may upload your database (CSV) file and image files to your Yahoo store via FTP. However, it's important to note that 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.
FTP Client Settings
User ID: 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
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 is not included in the data file, it will 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 (do not include a file extension).
- All image files must be named according to their ID (e.g. "id.gif"), and must have a .gif extension, regardless of the native format of the images.
- Images cannot 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 will not 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.
Uploading Files to the "Files" Directory
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 will not 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.
Important Note About ZIP Files
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 are not supported.
Important Notes About the "Data" File
- The first line of the CSV defines your item types and templates. For 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. Do not 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 will be using these same section names later in the path field of individual items, and the Editor will create objects based upon those names. You will 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 are 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 terminus, or "leaf."
Important Notes About Images
An img.zip is not required for all uploads. If you are not creating any new items it can be omitted. However, if you are 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 are 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.