Headers
suppid
Id
code
manufact
urer
manufact
urer-partnumber
our-cost
sale-price
price
map-price
Checklist
put the supplier id in this
column
id will be provided to you, do
not make it up on your own.
Product id's will generally
start with a 4 letter prefix and
001, 002 id is ALWAYS lower
case, and unique
Same as id column just in
caps lock. CODE is ALWAYS in
upper case and unique
place the manufacturer
name/brand in this column do not include LLC, Inc, or any
other such acronyms
place the mpn/item sku in this
column
place cost column here
For anything under $34.9 do
our cost plus 12. For $35 and
up do our cost times 135%.
Then make sure it's converted
to values.
Do sale-price times x 135%.
Then make sure it's converted
to values
If no MAP leave blank, If
there's map, place it here.
1. Make a new column called
equation and enter map
minus sale-price.
2. For items where the
equation number is a
negative (below 0), delete it
from the equation column and
go to step 9.
3. Items that have a positive
number in the equation field,
make a new column called
ship equation, and do shipweight minus equation.
4. Update ship weight field so
For Our cost values less than
34.9=Our cost+12,For Our cost
values greater than 34.9=Ourcost*135%
Price=Sale price * 135%
Refer Word Doc
name
headline
that any item which has a
lower than 1 in the ship
weight equation is changed to
0, and delete from ship
equation field, anything that's
1 and greater leave as is and
that reflects updated ship
weight.
5. Hard code what's left in the
ship equation column (>1)
and paste it back into the
ship-weight column.
6. Delete ship equation
column
7. Use the populated fields in
the equation column (which
at this point should only have
positive numbers) as a guide
for copying map into the saleprice column, so that sale
price reflects MAP.
8. Update price column to
reflect 135% markup from
sale price.
9. Delete equation column.
Do manufacturer plus
manufacturer-part-number
plus an item name to get this
column. The only characters
allowed in this field are commas, periods, numbers,
and "&" signs. These are
some examples of some
restricted characters:
exclamation points, quotes,
apostrophes, question marks,
dollar signs, number signs,
slashes, parentages, degree
signs, semi-colons...
***Make note - Name should
be at least 3 words besides
for the mfg name and MPN
copy what's in name and
paste here
1.Manufacture+MPN+Product
type+(Any related info in Input filed
like Size,color,Dimensions).2.Insert
a column before the NAME
column.3.Formula to remove the
Duplicates if MPN is available in the
NAME ,Name=REPLACE(K2,1,
(LEN(D2&" "&E2)+1),"").4.If MPN is
not given use this
Name=REPLACE(K2,1,
(LEN(D2)+1),""). Here K2
corresponds to Name.,D2
Corresponds to Manufacturer & E2
Corresponds to MPN
caption
shipweight
upc
ystkeywords
path
fullpath
orderable
taxable
producturl
dataMissi
Place a description into this
column. Include as much
information as possible,
romance copy, bullet points,
and item dimensions. This
field should be in html format.
See attached for html table
***Make note - Caption should
have at least 60 characters of
copy for each item
Put in weight (number only,
no lbs, kg...).Ship weight is
minimum of 3 lbs. For items
that are marked as ships
freight/LTL/truck, raise the
ship weight to a minimum of
150. Also if there's a drop
ship fee (DSF) for the line,
make sure to add that
amount to the ship weight
(for example, an items that
weighs 5, and has a 2 DSF,
the ship weight will be 7).
This field may be affected by
MAP, refer to MAP field for
additional information and
instructions where MAP is
applicable.
put in upc when provided
put in any category words
provided by supplier, here
Use "categoryid" from
categorypaths.csv here. Very
important
enter the fullpath field that
corresponds to the
"categoryid" in path
write yes in this column
write yes in this column
Once image is renamed to
"id", place the image name
here. Include the image ext,
for example abc001.jpg
MPN,Cost,Name,Caption,Ship
Insert a Column next to CAPTION
Column. Select the CAPTION
column->Data->Advanced. Add 1 in
the new column->Alt + : ->Then
paste it for full column->Now filter
out the blanks->Fix the Duplicates
Shouldnt leave blanks
ng
weight,Path,Image, count 1
for each field depend upon
the missing and update the
field according to the missing
fields
