File structure for Massive Listing

The following table will help the reader to comprehend what was added, removed and updated along the version of the software.

Revision

Date

Details

6

18 December 2010

On file Excel: add of the field “Condition”

5

26 March 2010

On file Excel: add of the field eDockCategory

4

2 December 2009

On file Excel: add of the field Image4, Image5

3

16 November 2009

On file Excel: add of the field MoneyXferAccepter, Libero2, Libero2, Libero3, Libero4, Libero5.

Adjustment of:

MOOCAcceptet (Not bank transfer but Money order)

PersonalCheckAccepted (not Money order but cheque)

Add: explanation for the creation of the template and dynamic box (added massively)

2

16 November 2009

On Excel: Add explanation of the field of Excel file and code to use in a given field

1

23 October 2009

Creation of the document

 

 

File field description on Excel

File Excel

Name field

Description

Type

Example

Title

Name of the item

String LG

Electronics 32LF2510 black

Subtitle

Short description

String

LCD television 32”

Description

Long description

String

LG Tv Full HD 22” with decode, brightness 500cd/m2, Slot Common Interface, 2 HDMI

SKU

Item code

String

32LF2510

Cateogory 1

Category

eBay code

298

Category 2

Subcategory

eBay code

298

Store category 2

Shop category

eBay code

1

Quantity

Shop subcategory

eBay code

10

Duration

How much the advertisement lasts

Duration code

Days 3, GTC

 

Startprice

Price of selling

Decimals

15.21

HitCounter

Form of the counter

Count code

BasicStyle

ProPackPlusBundle

Visibility pack plus

Yes/No

Yes

Featured

Shop window plus

Yes/No

Yes

BoldTitle

Title in bold

Yes/No

Yes

Border

Presence of the border

Yes/No

Yes

Highlight

Advertisement highlight

Yes/No

Yes

 

 

ShippingMethod1

Method of Shipping

Domestic Shipping code

IT_QuickPackage1

ShippingMethodCost1

Cost of shipping

Number

5

ShippingMethod2

Method of Shipping

Domestic Shipping code

IT_QuickPackage1

ShippingMethodCost2

Cost of shipping

Number

5

ShippingMethod3

Method of shipping

Domestic Shipping code

IT_QuickPackage1

AdditionalItemCost

Additional Shipping cost per item

Number

2

 

AdditionalInternationalItemCost

Additional Shipping cost per item

Number

2

InternationalInsuranceOption

Insurance options

Insurance code

NotOffered

InternationalInsuranceAmount

Insurance costs

Number

30

InternationalInsuranceDetails

Insurance Details

String

 

 

PayPalAccepted

PayPal payment accepted

Yes/No

Yes

PayPal Account

 

String

username@domain.com

MoneyXferAccepted

 

Yes/No

Yes

MOCCAccepted

Money order Accepted

Yes/No

Yes

PersonalCheckAccepted

Cheque Accepted

Yes/No

Yes

VisaMCAccepted

Credit Card Accepted

Yes/No

Yes

CODAccepted

Cash on Delivery accepted

Yes/No

Yes

CODCost

Cash on Delivery costs

Number

5

Refund Option

Refund policy

String

 

 

Image1

File name of the first image

String / URL

Lg-electronics-1.jpg

Image2

File name of the second image

String / URL

Lg-electronics-2.jpg

Image3

File name of the third image

String / URL

Lg-electronics-3.jpg

Image4

File name of the fourth image

String / URL

Lg-electronics-4.jpg

Image5

File name of the fifth image

String / URL

Lg-electronics-5.jpg

Attributes

Item attributes

String

See the following table

 

Libero1

Free text added to a template

String

We are open from Monday to Friday, from 8 am to 12 am and from 2 pm to 6 pm

Libero2

Free text added to a template

String

As Libero1

Libero3

Free text added to a template

String

As Libero1

Libero4

Free text added to a template

String

As Libero1

Libero5

Free text added to a template

String

As Libero1

 

eDockCategory

Item category on eDock Product and Selling

String

Ring ¶ gold ¶ measure 6

Condition

Items conditions (see table below)

String

1000

 

 

eBay Categories (see table below)

Code duration of the advertisement

Days_3

-

Days_5

-

Days_7

-

Days_10

-

Days_30

-

GTC

No deadline

 

 

 

Counter codes:

NoHitCounter

BasicStile

RetroStile

HiddenStyle

 

 

Code for National Shipping:

ExpressCourier

QuickPackage2

QuickPackage3

RegularPackage          

ExpressPackageMaxi

InsuredMail

QuickMail        

RegularMail

PriorityMail

MailRegisteredLetter

MailRegisteredLetterWithMark  

PickUp

PromotionalShippingMethod

 

International Shipment:

ExpeditInternational     

StandardInternational   

FOtherInternational

 

 

 

International areas (to insert more than one, separate the codes in with comma delimiters):

America

Asia

AU

CA

EuropeanUnion

US

Worldwide

DE

FR

Europe

CB

JP

None

 

 

International areas (to insert more than one, separate the codes in with comma delimiters):

IncludedInShippingHandling

NotOffered

Optional

Required

 

Ensurance:

IncludedInShippingHandling

NotOffered

Optional

Required

 

 

 

Attributes

To guarantee the highest flexibility, you can insert the attributes of the products in a file cell.

The format is the following:

 [AttributeSetName] { x[AttributeName]=AttributeValue; ... }

Where:

  • AttributeSetName = name of the Attribute set created on Products on eDock
  • x = type of attribute generate on Products
  • s = String
  • b = Yes/No
  • c = dropdown
  • n = integer number
  • d = decimal number
  • AttributeName = name of the attribute
  • AttributeValue = string that identificates the attribute value

For example:
[Televisions] { c[Type]=LCD; s[Model]=32LF2510; b[HDMI]=1; b[Digital Decoder Integrated]=1; }

NB.

Among the attributes you can insert the product’s EAN code, the string used is the following:

  • [Bar Code] { s[Bar Code]=INSERT HERE THE CODE; c[Type of bar code]=3; }

 

Template for the listing

The template of the listing – that has to be submitted to eDock4eBay Massive – must be a html file. In this file you can use these placeholder:

  • ##NOMEPRODOTTO##: changed with the field Title in the Excel file
  • ##DESCRIZIONE##: changed with the field Description in the excel file
  • ##ATTRIBUTI##: changed with a table having the attributes specificated in Attributes
  • ##SKU##.changed with the field: item code
  • ##IMMAGINE1##: changed with the image whose path is in field Immagine1
  • ##IMMAGINE2##: changed with the image whose path is in field Immagine2
  • ##IMMAGINE3##: changed with the image whose path is in field Immagine3
  • ##IMMAGINE4##: changed with the image whose path is in field Immagine4
  • ##IMMAGINE5##: changed with the image whose path is in field Immagine5
  • ##LIBERO1##: changed with the field Libero1
  • ##LIBERO2##: changed with the field Libero2
  • ##LIBERO3##: changed with the field Libero3
  • ##LIBERO4##: changed with the field Libero4
  • ##LIBERO5##: changed with the field Libero5

Example of placeholder in the HTML code

<h2 class="title"><strong>##NOMEPRODOTTO##</strong></h2>

(This code tells to write the name of the product in h2 and in bold style, as this was a title of second level)

N.B.

Images and their placeholder ##IMMAGINE##
the value written in Immagine1, Immagine2 o Immagine3 could be:

ATTENTION: it is important that it begins with http://

A path related to your folder “images” on eDock Product and Selling as, for example, elettronica/telefoni/1.jpg or elettronica/batterie/1.jpg. In this case the image is taken from eDock and replaced with a path similar to:

 

Free fields and dynamic box

If you want to include a dynamic box directly on your listing’s template, do as follows:

  1. Create the template adding, where you want to locate the dynamic box, the placeholder ##LIBERO1##
  2. In the column related to the Excel files Libero 1 add the following string html: <img src=”http://dynamicboxes.edock.it/getimage.aspx?user=nomeutente&file.../>

Dove:

  • Filename is your user name used to log in on eDock
  • nomebox is the name of the Dynamic box created on eDock

Products conditions

 

 

Code that have to be inserted in the file

Correspond to

1000

New

3000

Used

175

New with defects

2750

Like new

4000

Very good

5000

Good

6000

Acceptable

2000

Remanufactured

2500

Seller refurbished

7000

For parts or not working

 

 

Have more questions? Submit a request

Comments