Help With Csv File for Product Upload
Importing Products from CSV
Easy Digital Downloads has the ability to import products via a CSV format, either from a from another shop or import new products in bulk. If you are importing products from another store, see our export guide here.
Product importing is washed nether Downloads → Tools → Import/Consign. On this page yous'll detect a box labelled Import Download Products.
Importing New Products In Bulk
You can import new products to your store in bulk via CSV. It's recommended y'all test the import process with one or two products before importing a large number. Likewise the procedure is easier if you keep your file names consistent with your product name to make providing file paths as unproblematic as possible. Run into the steps beneath to import a large number of products:
- Upload your Featured Images to your Wordpress site'southward media directory. You can skip this step if you are not using Feature Images.
- Upload the Downloadable files:
- If storing files in Wordpress, upload to the EDD directory (uploads > EDD). You'll need to upload via FTP considering yous won't see this folder via the WordPress media uploader.
- If storing on Amazon S3 or Dropbox, information technology's all-time to upload straight to Amazon or Dropbox. The file path is non the aforementioned as Amazon's S3 or Dropbox'southward file path, then we recommend manually creating a Download, "Upload a File" and add a file from your Amazon bucket. Employ that file path as a template for Download path in the next step.
- Setup your CSV file with the products you want to import, see below for details. Insert the Featured Paradigm URL and Download path to the CSV (obtained in the steps higher up). For an example CSV file, make sure your store contains at to the lowest degree one Download and download a CSV of download products from your store. Run into our export guide here.
CSV Format
Your CSV should exist comma separated, with fields enclosed by double quotes. The order of the fields is not important, as you'll exist mapping them in the adjacent step.
Uploading
Click Choose File and browse to your file. Then click Import CSV.
Mapping
In one case your file is uploaded y'all'll come across a list of Payment fields that demand content, and a dropdown for each one, where you tin can map where the data is. Each dropdown will be populated with content from your CSV, so you'll be able to map accurately.
Additionally, every bit you cull a column, a value from the column will appear on the right, taken from the first row of information, equally in the example below.
Annotation: If no data appears in the correct cavalcade it is NOT a problem. That merely indicates that the row being used for examples doesn't contain information for that column.
Required Fields
The more fields yous accept the more complete your site data volition be, which can be helpful when working with financial statements or customer information. That said, the actually vital fields are the Product Championship, Download Files, andProduct Toll(southward).
Importing From Non-EDD Systems
Easy Digital Downloads is looking for this information in its import:
| Product Field | Expected Information Type |
|---|---|
| Product Author | Requires a numerical WordPress ID |
| Production Categories | This accepts either a single plain text string for a category, or several separated past vertical bar similar |, and tin can await similar this: Ebook | Marketing |
| Product Creation Date | Any standard date format |
| Product Clarification | Whatever plainly text string. |
| Product Excerpt | Any plain text string. |
| Production Image | A valid spider web address of an epitome. |
| Product Notes | Any evidently text string. |
| Production Price(s) | This field is for prices. Input can be a number like this: 1.00 or information technology tin be a cord like this: Monthly: 10.00 Multiple prices are separated with a vertical bar similar |, and can look like this: Monthly: 10.00 | Yearly: 120.00 |
| Product SKU | This field accepts whatever evidently text string. An example is: AAMAM2016 |
| Product Slug | This field accepts a tests tring formatted like a WordPress slug. Case: my-cool-plugin. If no slug is specified, one will be machine-generated. |
| Product Status | One of these statuses: Published, Pending Review, Draft, Future |
| Product Tags | This accepts either a single plainly text string for a category, or several separated past vertical bar like |, and can look similar this: Ebook | Marketing |
| Production Championship | Any apparently text string. |
| Download Files | This field can accept a valid web address of a file, an absolute path on a filesystem, or the bucket/filename.ext on an Amazon S3 instance. Muitlple files are separated by vertical bar like |. Note that file names tin non be entered separately merely will be automatically generated using the file's name. |
| File Download Limit | A number |
| Sale Count | A number |
| Full Earnings | A currency value like 42.00 or 900 or 782.0000000 |
An example screenshot with the fields mapped properly, and example data showing in the right cavalcade.
REMEMBER: it's ok if there isn't information showing in the right cavalcade, some fields are but empty.
FAQ and Troubleshooting:
Volition duplicate files be created upon import?
If the same file is used for different products, whether every bit the deliverable or the featured image, a new, duplicate version of that file volition be imported and stored on your server. The CSV Importer will not re-utilise files if they already exist on the server.
Can I import product bundles?
No, not at this fourth dimension.
jacksonnoestringthe.blogspot.com
Source: https://docs.easydigitaldownloads.com/article/887-importing-products-from-csv
0 Response to "Help With Csv File for Product Upload"
Post a Comment