如果我们需要一个个上传产品的话这样比较麻烦,而且也比较耗时,所以这个时候如果能直接批量上传的话可以为我们节约很多的时间,接下来,我们就来看看具体要如何操作。
首先我们进入shopify的后台,在product->import,选择下载一个示例csv文档。
或者是如果觉得示例文档看的还不是很好理解的话我们可以先上传几个产品再导出,这样可以有一个参考。
找到product->export,选择all product或者是部分产品都是可以的,选择CSV for Excel, Numbers, or other spreadsheet programs,点击export itemsj即可。
csv文件的功能不仅仅是用来批量上传产品,还有以下情况也会用到:
1、把shopify网站A的数据导出,然后上传到shopify网站B中。
2、上传下载网站的客户信息
3、网速如果不好的情况下,用表格操作可以节省很多的时间。
在下面我们可以看到一个提示you can also use the bulk editor to edit your products.
点开这个蓝色的锚文本,我们可以选择多个想要修改的模块进行批量的修改。包括价格,url,sku,产品标题等等,这个功能也是比较方便的。
<br />
导出的这个步骤很简单,真正麻烦的是填写,如果填写不正确的话重新导入的时候会报错,导入不了数据回系统中。所以接下来大家讲解下表格中各列代表的含义。
Handle(必填项)
我们先从第一个Handle来看,这里显示的是我们产品seo部分的URL的后缀,可以是小写字母和数字,由“–”中划线连接,中间不能有空格。
在批量上传表格中,每个产品的handle都是唯一的,不能相同。如果要为一个产品添加多个图片,则每添加一行图片地址,就要对应的复制一次Handle。Handle内容不同则表示是不同的产品。
Title(必填项)
这个比较简单,就是我们的产品名称。如图所示后台的位置。不同的产品,title可以一样,但是产品的Handle即url是不同的,可以在url中标注产品不同的属性。例如:summer-skirt-xl,summer-skirt-s
Body (HTML)
这个指的是产品的描述部分,可以直接填写纯文本,不过还是建议用html语言来写,这样可以直接用代码就把排版完成了,不用后期再去调整排版。
如果不懂html代码也没有关系,不知道大家有没有注意到在我们shopify后台描述这边有一个小小的像括号一样的符号,我们可以在这里编写完文字之后点击下show html就可以展现html代码了。如图:
把这些代码直接复制到我们的csv表格中就可以啦~是不是很简单呢~
Vendor&Type&Tags
这三个分别对应的就是我们shopify后台右侧的数据。
Vendor这个很好理解,就是我们的产品供应商名称,如果不做修改的话默认的是店铺名字。例如我的店铺是fashion,每一行填写这个就可以了。
Product type(选填) 产品类型,比如我这个产品是杯子,那我产品类型可以写cup或者是glass
Tags(选填)产品标签,比如情侣杯,陶瓷的,玻璃的。这个根据自身产品的标签来写。
Published
这里表示产品是否发布,TRUE表示立即发布,FALSE表示暂时作为草稿不发布,如果留空不填写的话也表示立即发布。
Option1 Name——Variant Barcode
这中间所有的内容都是变体的设置,就是可配置多属性产品。一个产品可以设置多个不同的属性,不同的sku,不同的价格,不同的数量。如果是简单产品,没有变体的,这个部分可留空。表格中对应的就是后台的这个位置:
目前shopify只可以添加3种属性,对于大多数的用户来说这个是够用的,默认的属性是Size,Color和Material。不过这些都是可以自己修改的。变成想要属性。这里要注意的是单个属性值的数量限制为100,多个属性值的话,他们的乘积不能超过100。(就是说如果材质有10个的话,那么添加的颜色数量最多为10)。所以我们在填写表格的时候也要特别注意,先计算好之后再填写,以防添加的属性过多最后无法上传。
Image Src
产品图片的url地址。如果我们引用的是第三方的路径的话,shopify会自动抓取url并将该图片下载并重新上传到shopify的服务器。这里填写的图片是无法与不同属性的子商品一样对应起来的,我们需要在表格后面的Variant Image中为每个子商品填写对应的图片链接。
关于shopify图片命名的具体内容可以看这篇文章:
https://www.trafficcn.com/optimize-shopify-picture
也可以直接在shopify后台先上传所有的图片,系统会自动生成链接,我们直接在表格中引用就可以了。
点击Settings->Files
找到Upload files,选中想要上传的图片,可一次性选择几百张图片进行批量上传,但是注意不要超过300张,选择太多张的话会导致上传失败。然后复制url链接至csv表格中即可。
在这里我们可以看到当图片上传完之后会生成唯一的handle,即url,不能修改。只能直接删除整个图片重新上传,所以在命名图片名字的时候要特别注意。
Image Position
这个很简单,就是图片显示的顺序,可填写数字1,2,3,4…,数字越小,图片排的越靠前,数字1的图片是产品主图。
Image Alt Text
图片的ALT标签(选填)但是站在seo的角度是建议大家填写的。当图片打不开的时候就会显示alt标签,可以通过alt标签来判断显示的内容是什么。用产品关键词来命名。
Gift Card
说明该产品是否是礼品卡。29美金每月的账户都是不支持gift card的功能的,默认的就是FALSE。79美金以上每月的用户可以根据实际情况选择TRUE或者是FALSE.在表格中还可以编辑礼品卡的详细信息。但要注意的是礼品卡只能在shopify管理员中创建并激活。无法直接通过产品csv创建礼品卡。
SEO Title&SEO description
SEO标题和描述,这个是产品在搜索引擎搜索结果页面显示的内容,决定了用户在搜索的时候是否有兴趣点击进入你的网站进行查看。这里要注重seo标题要控制在70个字符以内。描述控制在320个字符以内。如果留空的话则系统会自动填入产品标题和产品描述。
更多关于seo标题和描述的详细介绍可以看这篇文章:
https://www.trafficcn.com/optimize-shopify-url
Google Shopping / Google Product Category——Google Shopping / Custom Label 4
这几列的内容是安装了google shopping APP之后才需要填写的内容,包含产品目标用户的年龄,性别,产品类别,广告分组等等。
Collection
在shopify的后台我们可以看到还有一个collection,起到产品分类的功能,那我们发现在csv表格中是没有体现的,我们可以使用标题名称Collection在CSV文件中的任意位置添加一个新列。
但是要特别注意的是Collection列是可以添加到CSV中唯一不会破坏格式的列。其余自己创建的列都有可能导致产品上传异常。
填写完csv文件之后也是在product->import中上传,可以勾选上覆盖已有产品。这样就不会一个产品重复上传。
如果你一次性就上传成功了,那恭喜你,你真棒!也有一些人在上传的过程中可能会上传失败,那常见的提示都有哪些呢?
下面给大家列举了15条并给出解决方法:
1、Fulfillment service can’t be blank
发货方式不能为空,如果是自发货,需要填写为manual。在表格中对应修改的列为Variant Fulfillment Service。
2、Ignored line #-## because handle example already exists
表格里面的handle一列,不同的产品必须不能重复。如果出现重复,则会出现如上错误提示。
3、Ignored line #-## because it did not contain product data
出现上面错误提示,表示该行有handle列url的信息但是没有Title列的信息。
1、Illegal quoting on line
有可能是字符编码错误,请查看是否有乱码,也有可能是引号错误。为了尽可能的避免错误,书写表格内容时要全部使用英文字符。是英文字符下的引号””,而不是中文状态下的引号“”。
这里最容易出现错误的是Body (HTML)这一列,可以先从这里排查起。
2、Incorrect header check
将提示的错误行的图片URL删除掉之后重新上传表格,看看还有没有错误提示。如果没有了的话换一个图片托管的工具看一下。如果是直接在shopify后台上传的图片一般不会出现这个提示。
3、Invalid CSV header: missing headers
这个提示表示表格第一行有错误。要确保是以下的Field Name:
Handle,Title,Body (HTML),Vendor,Type,Tags,Published,Option1 Name,Option1 Value,Option2 Name,Option2 Value,Option3 Name,Option3 Value,Variant SKU,Variant Grams,Variant Inventory Tracker,Variant Inventory Qty,Variant Inventory Policy,Variant Fulfillment Service,Variant Price,Variant Compare At Price,Variant Requires Shipping,Variant Taxable,Variant Barcode,Image Src,Image Alt Text
如果检查了这些Field Name没有错误的话,要确保这些单词末尾没有空格。这一行导出的时候已经固定好了,除了添加Collection列之外不需要再去改动的。
4、Inventory policy is not included in the list
库存跟踪不能为空,这是必填项。请选择 ‘deny’ 或者 ‘continue’。
需要检查Variant Inventory Policy列。
5、Inventory quantity can’t be blank
库存数量不能为空,是必填项。如果不需要追踪库存的话,则要确保Variant Inventory Tracker列为空,否则shopify会查找库存数量的。
6、Inventory quantity is not a number
库存数量不是一个阿拉伯数字。请确认表格里面的库存数量为阿拉伯数字。
7、Missing or stray quote on line
引号使用错误。请确保使用的是英文字符下的引号””,而不是中文状态下的引号“”。
这个容易出错的列是Body (HTML)。
8、Validation failed: An error occurred while trying to download the image
验证失败,在下载图片的时候错误。图片丢失了。
如果是在shopify后台上传的可以尝试把链接?后面的内容删掉,包括问号再上传看能否成功。
例如将
https://cdn.shopify.com/s/files/1/0060/6185/0682/files/necklace.jpg?15415205376426262080
修改为
https://cdn.shopify.com/s/files/1/0060/6185/0682/files/necklace.jpg
9、Validation failed: getaddrinfo: nodename nor servname provided, or not known
出现这个错误提示通常是因为产品图片的url地址出现了错误。请确保图片地址以http://或https://开始。另外请确认图片地址是可以公开访问的。也就是说图片地址以.jpg或.png等格式结尾。
10、Validation failed: options are not unique
出现这个错误提示是说,你的表格里面的变体属性信息有重复内容。例如Color写了两个black。或者Size写了两个large。
11、Validation failed: price can’t be blank
价格不能为空。是必填项。
12、Validation failed: The uploaded image exceeds the 20 megapixel limit
上传的图片超过了2000万像素的限制。产品图片可以是任意尺寸,但是最高不能超过5760*5760,需要减小图片的像素大小。
这里建议大家把图片都进行压缩之后再上传,图片过大会影响网站打开的速度。
如果大家遇到了更多的问题也可以在下方留言一起讨论。
很多人下载了csv文件之后第一眼觉得一脸懵,怎么有这么多要填的数据,这些数据都是什么意思,怎么填,但其实看完这篇文章之后会发现我们把每一个都分解开,再跟shopify后台对应起来就一点都不难了,只是看我们肯不肯迈出第一步,只要尝试了就有了一个好的开始,接下来的步骤都没有那么难了。
最后附上一份shopify英文的官方解释,英文比较好的小伙伴也可以直接参考这份资料~
Handle |
Handles are unique names for each product. They can contain letters, dashes and numbers, but no spaces. A handle is used in the URL for each product. For example, the handle for a “Women’s Snowboard” should be womens-snowboard, and the product’s URL would be https://yourstore.myshopify.com/product/womens-snowboard. Every line in the CSV that starts with a different handle is treated as a new product. To add multiple images to a product, you should add multiple lines with the same handle. |
||
Title |
The title of your product. Example:Women’s Snowboard |
||
Body (HTML) |
The description of the product in HTML format. This can also be plain text without any formatting. |
||
Vendor (min. 2 characters) |
The name of the vendor for your product. For example, John’s Apparel. |
||
Type |
The Product type. For example, Snowboard. |
||
Tags (can be left blank) |
A comma-separated list of tags used to tag the product. Most spreadsheet applications automatically add quotes around the tags for you. If you are using a plain text editor, you will need to manually add the quotes. For example, “tag1, tag2, tag3”. |
||
Published |
States whether a product is published on your online store. Valid values are TRUE if the product is published on your online store, or FALSE if the product is hidden from your online store. Leaving the field blank will publish the product. |
||
Option1 Name |
If a product has an option, enter its name. For example, Color. For products with only a single option, this should be set to Title. |
||
Option1 Value |
If a product has an option, then enter its value. For example, Black. For products with only a single option, this should be set to Default Title. |
||
Option2 Name (can be left blank) |
If a product has a second option, then enter its name. For example, Size. |
||
Option2 Value (can be left blank) |
If a product has a second option, then enter its value. For example, Large. |
||
Option3 Name (can be left blank) |
If a product has a third option, then enter its name. |
||
Option3 Value (can be left blank) |
If a product has a third option, enter the value of the option. |
||
Variant SKU (can be left blank) |
The SKU of the product or variant. This is used to track inventory with inventory tracking services. This field can’t be left blank if you’re using a custom fulfillment service |
||
Variant Grams |
The weight of the product or variant in grams. Do not specify a unit of measurement or use decimals. For example, for a weight of 5.125 kg, enter 5125. Shopify will always import and export weight in grams, even if you specify a different unit. You must use accurate weights if you intend to offer carrier-calculated shipping or use a third-party fulfillment service. |
||
Variant Inventory Tracker(can be left blank) |
Include your inventory tracking for this variant or product. Valid values include shopify, shipwire, amazon_marketplace_web, or blank if inventory is not tracked. |
||
Variant Inventory Quantity |
The number of items you have in stock of this product or variant. |
||
Variant Inventory Policy |
How to handle orders when inventory level for this product or variant has reached zero. Valid values are deny, or continue. deny will stop selling when inventory reaches 0, and continue will allow sales to continue into negative inventory levels. |
||
Variant Fulfillment Service |
The product or variant fulfillment service used. Valid values are: manual, shipwire, webgistix, amazon_marketplace_web. If you use a custom fulfillment service, you can add the name of the service in this column. For the custom name, use only lowercase letters. Spaces aren’t allowed—replace them with a dash (-). Periods and other special characters are removed. For example, if “Mr. Fulfiller” is your fulfillment service’s name, enter mr-fulfiller in the CSV file. You must have a custom fulfillment service set up in your Shopify admin before you can add the name of the service in this column. |
||
Variant Price |
The price of the product or variant. Don’t place any currency symbol there. For example, 9.99. |
||
Variant Compare at Price |
The “Compare at Price” of the product or variant. Don’t place any currency symbol there. For example, 9.99. |
||
Variant Requires Shipping(blank = FALSE) |
The option to require shipping. Valid values are TRUE, FALSE, or blank. |
||
Variant Taxable (blank = FALSE) |
Apply taxes to this variant. Valid values are TRUE, FALSE, or blank. |
||
Variant Barcode (can be left blank) |
The barcode, ISBN or UPC of the product. |
||
Image Src |
Enter the URL for the product image. Shopify will download the images during the import and re-upload them into your store. These images are not variant-specific. The variant image columnis where you specify variant images. You won’t be able to change your image filename after that image has been uploaded to your shop. Don’t upload images that have _thumb, _small, or _medium suffixes in their names. |
||
Image Position |
Enter the number that represents the order in which you want the image to appear on the product’s page. The images will appear in order from smallest to largest starting from an image position value of 1. For example, enter 1 if you want the image to appear first for that product. |
||
Image Alt Text (can be left blank) |
Alt (alternate) text describes an image and is an important part of a product description. If an image can’t load for any reason, then alt text is shown instead. It’s also used by assistive technology to describe an image to a customer who’s visually impaired. Including alt text will boost your website’s SEO. Keep your alt text brief and descriptive. The maximum length is 512 characters, but 125 or less is recommended. |
||
Gift Card |
States whether the product is a Gift Card or not. Valid values are TRUE, or FALSE. The addition of this column also allows you to edit other Gift Card details, such as the Body or Tags columns, and import these changes. A gift card can only be created and activated in the Shopify admin. You can’t initially create a gift card through a product CSV import. |
||
Variant Image |
The url for images of variants. |
||
Variant Weight Unit |
Valid values are `lb`, `kg`, and `oz`. |
||
Variant Tax Code SHOPIFY PLUS |
The Avalara code to apply taxes to this product. This field applies only when you are importing to or exporting from a store that uses Shopify Plus’s integration with Avalara AvaTax. When you create a CSV file by exporting products from a store that uses Avalara, the Variant Tax Code field is populated. If you import this CSV file into a store that doesn’t have Avalara set up, then your import will fail. |
||
SEO Title (does not require the Google Shopping App) |
The SEO Title is found on a product’s details page under the Search engine listing preview header in the Page title field. The SEO Title has a character (letters and numbers) limit of 70. If you leave this field blank when importing a product, the field is automatically populated with the product title. |
||
SEO Description (does not require the Google Shopping App) |
The SEO Description is also found on a product’s details page under the Search engine listing preview header in the Meta description field. The SEO Description has a character (letters and numbers) limit of 320. If you leave this field blank when importing a product, the field is automatically populated with the product description. |
||
Google Shopping / Google Product Category |
Google has a proprietary set of product categories. The full list is quite large to allow merchants to be specific towards their target audience. You can upload any value you want using the CSV file, however if your language format does not match Google’s full product taxonomy, you might not be able to publish the products to Google. |
||
Google Shopping / Gender |
What gender does this product target? Valid values are Female, Male, or Unisex |
||
Google Shopping / Age Group |
What age group does this product target? Valid values are Adult or Kids only. |
||
Google Shopping / MPN |
The MPN, or Manufacturer Part Number, is a string of alphanumeric digits of various lengths (0-9, A-Z). |
||
Google Shopping / AdWords Grouping |
This is used to group products in an arbitrary way. It can be used for Product Filters to limit a campaign to a group of products, or Product Targets to bid differently for a group of products. You can enter any “string” data (letters and numbers). |