开发者

magento import image attribute not inserting in table

开发者 https://www.devze.com 2023-01-20 20:05 出处:网络
I have following fields in my csv store websites attribute_set type category_ids sku has_options name meta_title

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开发者_如何学JAVA
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.


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.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消