magento导入图像属性未插入表中
我的 csv 中有以下字段
store
websites
attribute_set
type
category_ids
sku
has_options
name
meta_title
meta_description
image
small_image
thumbnail
url_key
url_path
custom_design
page_layout
options_container
gift_message_available
size
caseprice
newbrand
weight
price
special_price
cost
status
tax_class_id
is_recurring
visibility
enable_googlecheckout
description
short_description
meta_keyword
custom_layout_update
special_from_date
special_to_date
news_from_date
news_to_date
custom_design_from
custom_design_to
qty
min_qty
use_config_min_qty
is_qty_decimal
backorders
use_config_backorders
min_sale_qty
use_config_min_sale_qty
max_sale_qty
use_config_max_sale_qty
is_in_stock
low_stock_date
notify_stock_qty
use_config_notify_stock_qty
manage_stock
use_config_manage_stock
stock_status_changed_automatically
use_config_qty_increments
qty_increments
use_config_enable_qty_increments
enable_qty_increments
product_name
store_id
product_type_id
product_status_changed
product_changed_websites
除了图像、缩略图和小图像之外，所有字段都正确插入。 我已将路径指定为 \media\catalog\product\im 我给出的图像路径为 im/abc.jpg 导入时应该插入3个属性id 74,75,76。但现在它没有插入catalog_product_entity_varchar 桌子 请建议 coln。
I have following fields in my csv
store
websites
attribute_set
type
category_ids
sku
has_options
name
meta_title
meta_description
image
small_image
thumbnail
url_key
url_path
custom_design
page_layout
options_container
gift_message_available
size
caseprice
newbrand
weight
price
special_price
cost
status
tax_class_id
is_recurring
visibility
enable_googlecheckout
description
short_description
meta_keyword
custom_layout_update
special_from_date
special_to_date
news_from_date
news_to_date
custom_design_from
custom_design_to
qty
min_qty
use_config_min_qty
is_qty_decimal
backorders
use_config_backorders
min_sale_qty
use_config_min_sale_qty
max_sale_qty
use_config_max_sale_qty
is_in_stock
low_stock_date
notify_stock_qty
use_config_notify_stock_qty
manage_stock
use_config_manage_stock
stock_status_changed_automatically
use_config_qty_increments
qty_increments
use_config_enable_qty_increments
enable_qty_increments
product_name
store_id
product_type_id
product_status_changed
product_changed_websites
All the fileds are inserting properly except the image,thumbnail and small_image.
I have given the path as \media\catalog\product\im
The image paths i have given as im/abc.jpg
When importing it should insert 3 attribute id 74,75,76.But now it is not inserting in the catalog_product_entity_varchar
table
Please suggest the coln.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
关键步骤是文件需要位于 \media\import\ 文件夹中，如果是，则会自动找到并移动它们，否则将跳过图像字段，这就是您所看到的。
更完整的指南位于此处。
The key step is the files need to be in the \media\import\ folder, if they are then they are found and moved automatically, otherwise the image field is skipped and that is what you have seen.
A fuller guide is here.
您的 CSV 的问题是，您缺少产品图片导入所需的一些属性，即 "_media_image" 和 "_media_attribute_id"
当您在 CSV 中指定这些属性时，它将起作用。通过 CSV 导入图像的正确格式位于此处
有关更多详细信息，此链接对您来说是一个很好的阅读。
The issue with your CSV is, you are missing some required attributes for product images import i.e., "_media_image" and "_media_attribute_id"
It will work when you specify these attributes in CSV. The correct format for import images via CSV is here
For more details, this link will be a good read for you.