Bulk Registration/Change : Fields added in CSV file

Outline

The fields in the csv file will be added in [Shop Manager] > [Commodity Control] > [Bulk Registration/Change].
Refer to the following list for the items to be added..
shows the items that are added this time.

*Download and upload the selected fields in CSV file format

You can download and upload only the fields that you selected.
See the following linked page for details.

Modification date and time

December 1, 2010 at 11:00 a.m.

Current Layout
	Items	Details	e.g.
A	Control No.	Sequence numbers are entered automatically. Leave this cell empty when you register a new item. To update an existing item information, do not change this control number and use the same number.	1
B	Name of Item	Enter the name of an item * required item	NEW XYZZY Suit
C	Item No./Model No.	Enter the Item No./Model No., if needed.	TYPE
D	Category	Enter a category name that was, in advance, registered in the category list. If a category name is not on the list, it cannot be registered here. * required item	Men's
E	Sub Category	Enter a subcategory name that was, in advance, registered in the category list. If a subcategory name is not on the list, it cannot be registered here. If no subcategories are registered, leave this cell blank.	Suit
F	Group	Enter a group name that was, in advance, registered in the group list. If a group name is not on the list, it cannot be registered here. If it does not need to be registered in a group, leave this cell blank.	clothing Sale
G	Classification in Ochanoko Data	Please enter Classification in Ochanoko Data using numbers.	171
H	Selling Price	Enter a selling price using only numbers, with no comma. * required item	15800
I	Regular Price	Enter a regular price using only numbers, with no comma. If this item has an open (not fixed) price, enter the [Open Price]. To prevent displaying the regular price, leave this empty.	18000
J	Additional Points for This Item	Enter the number of extra points to be given in addition to each item. Enter only numbers, with no comma.	5
K	Stock Quantity	Enter a number for the stock quantity using only numbers, with no comma. Please enter [-99] if availability is not fixed.	10
L	Accept orders even when this item is not available.	To accept orders, even if the stock quantity is 0, enter 1.	1
M	Display of Low Stock	Enter the quantity to begin to display [Low Stock]. Use only numbers with no comma.	3
N	Unit Label	To use a unique label for the stock quantity, enter the label.	pics
O	Do not display the unit label	To have the unit label undisplayed, enter 1.	1
P	Label: Label	To use a label for the purchase quantity, enter the label.	quantity
Q	Label: Unit	To use a unit for the purchase quantity, enter the unit.	set
R	Maximum Purchase Quantity	If you wish to limit the purchase quantity, enter the maximum quantity a customer can purchase in a single transaction. Enter only numbers, with no comma.	10
S	Free Delivery	To apply the free delivery to the order including this item, enter 1.	1
T	Delivery Charge	Enter the delivery charge that is used if the purchases include only this item. Enter only numbers, with no commas.	500
U	Delivery Charge for the order including this item only (Individual Settings)	To apply the Individual Settings for the delivery charge, enter 1.	1
V	Required delivery charge (Separate Settings)	To apply the Separate Settings for the delivery charge, enter 1.	1
W	Weight for Delivery Charge Calculation	Enter a weight, used to set the weight-based delivery charge. Enter only numbers, with no comma.	10
X	Delivery Option 1	Enter [1] to apply Delivery Option 1.	1
Y	Surcharge for Delivery Option 1	If you selected [Single Charge] or [Delivery Charge by Area] and wish to apply Delivery Option 1 and a surcharge that is different from the surcharge set in the [Set Delivery Charge] screen., enter numbers, with no comma.	500
Z	Delivery Option 2	Enter [1] to apply Delivery Option 2.	1
AA	Surcharge for Delivery Option 2	If you selected [Single Charge] or [Delivery Charge by Area] and wish to apply Delivery Option 2 and a surcharge that is different from the surcharge set in the [Set Delivery Charge] screen., enter numbers, with no comma.	500
AB	Delivery Option 3	Enter [1] to apply Delivery Option 3.	1
AC	Surcharge for Delivery Option 3	If you selected [Single Charge] or [Delivery Charge by Area] and wish to apply Delivery Option 3 and a surcharge that is different from the surcharge set in the [Set Delivery Charge] screen., enter numbers, with no comma.	500
AD	Display Period (from)	To appoint the display starting time, enter the date and time such as YYYY-MM-DD HH or YYYY/MM/DD HH or YYYYMMDD HH.	2010-08-20 00
AE	Display Period (until)	To appoint the display ending time, enter the date and time such as YYYY-MM-DD HH or YYYY/MM/DD HH or YYYYMMDD HH.	2010-09-19 23
AF	Main Image1	Enter the file name of Image (Main Image). To upload the image file together with the CSV file, compress (zip) the CSV file and the image file, then upload the zip file. The zip file should be no larger than 10MB. Use a folder name such as aaa/suit.jpg that describes the image in the folder. A backslash "/" at the beginning is not required. Enter only alphabets and numbers.	suit1.jpg
AG	Main Image2	Enter the file name of Main Image 2 as Main Image 1.	suit2.jpg
AH	Main Image3	Enter the file name of Main Image 3 as Main Image 1.	suit3.jpg
AI	Main Image4	Enter the file name of Main Image 4 as Main Image 1.	suit4.jpg
AJ	Main Image5	Enter the file name of Main Image 5 as Main Image 1.	suit5.jpg
AK	URL linked from the main image	If you set the link from the main image, enter the URL.	http://
AL	Details	Enter the details of the item.	Explanation
AM	YouTube	If you set the You Tube, enter the URL.	http://
AN	Meta Title Tag	Enter the Meta Title Tag, if needed.	title
AO	Meta Description Tag	Enter the Meta Description Tag, if needed. You can use embedded tags here. See Embedded Tags	Description
AP	Meta Keyword Tag	Enter the Meta Keyword Tag, if needed. You can use embedded tags here. See Embedded Tags	Keyword
AQ	Introduction Line	Enter the Introduction Line, if needed. You can use embedded tags here. See Embedded Tags * Required, if a title of common element is entered.	Introduction
AR	Prerelease	Enter [1] to register the item in the Prerelease.	1
AS	New Items	Enter [1] to register an item in the New Items.	1
AT	Recommendations	Enter [1] to register the item in the Recommended Items.	1
AU	Undisplay Shopping Cart	Enter [1] to undisplay the shopping cart for the item.	1
AV	Common Element: Title	Enter the title of common element that was, in advance, registered in the common element list. A new title of common element cannot be registered here. To register multiple titles, separate them by line breaks. To inert line feeds, press Alt + Enter.	material color
AW	Common Element: Descriptions	Enter the description of common element. To register multiple titles, separate them by line breaks.	wool gray
AX	Other Image 1	Enter the file name of Other Image 1. Enter only alphabets and numbers.	suit1.jpg
AY	Item Details 1	Enter detailed information for Other Image 1.	Explanation
AZ	Other Image 2	Enter the file name of Other Image 2. Enter only alphabets and numbers.	suit2.jpg
BA	Item Details 2	Enter detailed information for Other Image 2.	Explanation
BB	Other Image 3	Enter the file name of Other Image 3. Enter only alphabets and numbers.	suit3.jpg
BC	Item Details 3	Enter detailed information for Other Image 3.	Explanation
BD	Related Items 1	Enter the Control No. of the item to register as a related item. You can register Up to 10 items as related items.	1
BE	Related Items 2
BF	Related Items 3
BG	Related Items 4
BH	Related Items 5
BI	Related Items 6
BJ	Related Items 7
BK	Related Items 8
BL	Related Items 9
BM	Related Items 10
BN	Delete	Enter [1] to delete the item.	1
BO	Selection Settings	Enter [1] to set the Selection Settings. Leave this cell blank if the item has no selections.	1
BP	Control Stock by Option	Enter [1] to control availability by option. Leave this cell blank if availability is controlled by item.	1
BQ	Selection Group 1	Enter the Selection Group Name.	SIZE
BR	Option for Selection Group 1	Enter an option for Selection Group 1. * Required when Selection Group 1 is set. * Please enter 2 or more selection items.	S
BS	Selection Group 2	Enter the Selection Group Name.	Color
BT	Option for Selection Group 2	Enter an option for Selection Group 2. * Required when Selection Group 2 is set.	Blue
BU	Selection Group 3	Enter the Selection Group Name.	Pattern
BV	Option for Selection Group 3	Enter an option for Selection Group 3. * Required when Selection Group 3 is set.	Stripe
BW	Stock by Option	Enter the stock quantity for each option. * This is required when [1] is entered at Control Stock by Option.	50
BX	Price by Selection	Enter the selling price for each option. Enter numbers only, with no comma.	15800

New Layout
	Items	Details	e.g.
A	Control No.	Sequence numbers are entered automatically. Leave this cell empty when you register a new item. To update an existing item information, do not change this control number and use the same number.	1
B	Name of Item	Enter the name of an item * required item	NEW XYZZY Suit
C	Item No./Model No.	Enter the Item No./Model No., if needed.	TYPE
D	Category	Enter a category name that was, in advance, registered in the category list. If a category name is not on the list, it cannot be registered here. * required item	Men's
E	Sub Category	Enter a subcategory name that was, in advance, registered in the category list. If a subcategory name is not on the list, it cannot be registered here. If no subcategories are registered, leave this cell blank.	Suit
F	Group	Enter a group name that was, in advance, registered in the group list. If a group name is not on the list, it cannot be registered here. If it does not need to be registered in a group, leave this cell blank.	clothing Sale
G	Classification in Ochanoko Data	Please enter Classification in Ochanoko Data using numbers.	171
H	Selling Price	Enter a selling price using only numbers, with no comma. * required item	15800
I	Regular Price	Enter a regular price using only numbers, with no comma. If this item has an open (not fixed) price, enter the [Open Price]. To prevent displaying the regular price, leave this empty.	18000
J	Additional Points for This Item	Enter the number of extra points to be given in addition to each item. Enter only numbers, with no comma.	5
K	Stock Quantity	Enter a number for the stock quantity using only numbers, with no comma. Please enter [-99] if availability is not fixed.	10
L	Accept orders even when this item is not available.	To accept orders, even if the stock quantity is 0, enter 1.	1
M	Display of Low Stock	Enter the quantity to begin to display [Low Stock]. Use only numbers with no comma.	3
N	Unit Label	To use a unique label for the stock quantity, enter the label.	pics
O	Do not display the unit label	To have the unit label undisplayed, enter 1.	1
P	Label: Label	To use a label for the purchase quantity, enter the label.	quantity
Q	Label: Unit	To use a unit for the purchase quantity, enter the unit.	set
R	Maximum Purchase Quantity	If you wish to limit the purchase quantity, enter the maximum quantity a customer can purchase in a single transaction. Enter only numbers, with no comma.	10
S	Free Delivery	To apply the free delivery to the order including this item, enter 1.	1
T	Delivery Charge	Enter the delivery charge that is used if the purchases include only this item. Enter only numbers, with no commas.	500
U	Delivery Charge for the order including this item only (Individual Settings)	To apply the Individual Settings for the delivery charge, enter 1.	1
V	Required delivery charge (Separate Settings)	To apply the Separate Settings for the delivery charge, enter 1.	1
W	Weight for Delivery Charge Calculation	Enter a weight, used to set the weight-based delivery charge. Enter only numbers, with no comma.	10
X	Delivery Option 1	Enter [1] to apply Delivery Option 1.	1
Y	Surcharge for Delivery Option 1	If you selected [Single Charge] or [Delivery Charge by Area] and wish to apply Delivery Option 1 and a surcharge that is different from the surcharge set in the [Set Delivery Charge] screen., enter numbers, with no comma.	500
Z	Delivery Option 2	Enter [1] to apply Delivery Option 2.	1
AA	Surcharge for Delivery Option 2	If you selected [Single Charge] or [Delivery Charge by Area] and wish to apply Delivery Option 2 and a surcharge that is different from the surcharge set in the [Set Delivery Charge] screen., enter numbers, with no comma.	500
AB	Delivery Option 3	Enter [1] to apply Delivery Option 3.	1
AC	Surcharge for Delivery Option 3	If you selected [Single Charge] or [Delivery Charge by Area] and wish to apply Delivery Option 3 and a surcharge that is different from the surcharge set in the [Set Delivery Charge] screen., enter numbers, with no comma.	500
AD	Display Period (from)	To appoint the display starting time, enter the date and time such as YYYY-MM-DD HH or YYYY/MM/DD HH or YYYYMMDD HH.	2010-08-20 00
AE	Display Period (until)	To appoint the display ending time, enter the date and time such as YYYY-MM-DD HH or YYYY/MM/DD HH or YYYYMMDD HH.	2010-09-19 23
AF	Main Image1	Enter the file name of Image (Main Image). To upload the image file together with the CSV file, compress (zip) the CSV file and the image file, then upload the zip file. The zip file should be no larger than 10MB. Use a folder name such as aaa/suit.jpg that describes the image in the folder. A backslash "/" at the beginning is not required. Enter only alphabets and numbers.	suit1.jpg
AG	Main Image2	Enter the file name of Main Image 2 as Main Image 1.	suit2.jpg
AH	Main Image3	Enter the file name of Main Image 3 as Main Image 1.	suit3.jpg
AI	Main Image4	Enter the file name of Main Image 4 as Main Image 1.	suit4.jpg
AJ	Main Image5	Enter the file name of Main Image 5 as Main Image 1.	suit5.jpg
AK	URL linked from the main image	If you set the link from the main image, enter the URL.	http://
AL	Details	Enter the details of the item.	Explanation
AM	Replace a line break with a <br /> tag	Enter [1] to replace a line break in the text with a <br /> tag.	1
AN	Replace URL with a link tag	Enter [1] to replace URL in the text with a link tag.	1
AO	YouTube	If you set the You Tube, enter the URL.	http://
AP	Meta Title Tag	Enter the Meta Title Tag, if needed.	title
AQ	Meta Description Tag	Enter the Meta Description Tag, if needed. You can use embedded tags here. See Embedded Tags	Description
AR	Meta Keyword Tag	Enter the Meta Keyword Tag, if needed. You can use embedded tags here. See Embedded Tags	Keyword
AS	Introduction Line	Enter the Introduction Line, if needed. You can use embedded tags here. See Embedded Tags * Required, if a title of common element is entered.	Introduction
AT	Prerelease	Enter [1] to register the item in the Prerelease.	1
AU	New Items	Enter [1] to register an item in the New Items.	1
AV	Recommendations	Enter [1] to register the item in the Recommended Items.	1
AW	Undisplay Shopping Cart	Enter [1] to undisplay the shopping cart for the item.	1
AX	Common Element: Title	Enter the title of common element that was, in advance, registered in the common element list. A new title of common element cannot be registered here. To register multiple titles, separate them by line breaks. To inert line feeds, press Alt + Enter.	material color
AY	Common Element: Descriptions	Enter the description of common element. To register multiple titles, separate them by line breaks.	wool gray
AZ	Other Image 1	Enter the file name of Other Image 1. Enter only alphabets and numbers.	suit1.jpg
BA	Item Details 1	Enter detailed information for Other Image 1.	Explanation
BB	Replace a line break with a <br /> tag	Enter [1] to replace a line break in the text with a <br /> tag.	1
BC	Replace URL with a link tag	Enter [1] to replace URL in the text with a link tag.	1
BD	Other Image 2	Enter the file name of Other Image 2. Enter only alphabets and numbers.	suit2.jpg
BE	Item Details 2	Enter detailed information for Other Image 2.	Explanation
BF	Replace a line break with a <br /> tag	Enter [1] to replace a line break in the text with a <br /> tag.	1
BG	Replace URL with a link tag	Enter [1] to replace URL in the text with a link tag.	1
BH	Other Image 3	Enter the file name of Other Image 3. Enter only alphabets and numbers.	suit3.jpg
BI	Item Details 3	Enter detailed information for Other Image 3.	Explanation
BJ	Replace a line break with a <br /> tag	Enter [1] to replace a line break in the text with a <br /> tag.	1
BK	Replace URL with a link tag	Enter [1] to replace URL in the text with a link tag.	1
BL	Related Items 1	Enter the Control No. of the item to register as a related item. You can register Up to 10 items as related items.	1
BM	Related Items 2
BN	Related Items 3
BO	Related Items 4
BP	Related Items 5
BQ	Related Items 6
BR	Related Items 7
BS	Related Items 8
BT	Related Items 9
BU	Related Items 10
BV	Delete	Enter [1] to delete the item.	1
BW	Management Note	This is only for administrative use and not displayed on a shop screen.
BX	Selection Settings	Enter [1] to set the Selection Settings. Leave this cell blank if the item has no selections.	1
BY	Control Stock by Option	Enter [1] to control availability by option. Leave this cell blank if availability is controlled by item.	1
BZ	Selection Group 1	Enter the Selection Group Name.	SIZE
CA	Option for Selection Group 1	Enter an option for Selection Group 1. * Required when Selection Group 1 is set. * Please enter 2 or more selection items.	S
CB	Selection Group 2	Enter the Selection Group Name.	Color
CC	Option for Selection Group 2	Enter an option for Selection Group 2. * Required when Selection Group 2 is set.	Blue
CD	Selection Group 3	Enter the Selection Group Name.	Pattern
CE	Option for Selection Group 3	Enter an option for Selection Group 3. * Required when Selection Group 3 is set.	Stripe
CF	Stock by Option	Enter the stock quantity for each option. * This is required when [1] is entered at Control Stock by Option.	50
CG	Price by Selection	Enter the selling price for each option. Enter numbers only, with no comma.	15800