Free adireshin lakabi bugu ga tsarin eBay masu sayarwa

If you are selling a few items per day on Ebay it might not be worth forking out on a dedicated selling manager that prints the address labels for you. Neither do you want to manually print the address label for each item sold as this can be time consuming and boring.

This free system will allow you to print the address labels in Microsoft Word. It also will print the item(s) kuma quanities zuwa jirgin da kuma shipping sabis, kunna ka ka tara, Package kuma post da abubuwa appropiately.

Domin yin amfani da wannan hanya za ka bukatar Microsoft Word 2007 / 2010 / 2013 .

The following will show you how to print address labels in Microsoft Word without the requirement for custom software.

Ɗawainiya yi a ebay.co.uk

Wadannan ayyuka da a yi a ebay.co.uk everytime kake son ka buga sabon adireshin tasirin.

1. Go to your sayar da abubuwa a cikin jerin eBay Selling Manager (My eBay -> Selling, to, za i Sold daga hagu menu)
   
2. Daga Status tace za i jiran aika
3. Duba duk akwati kusa da na sayar da abubuwa
4. Click the other drop down list and select download. This will download a csv file. Save the file in a dedicated directory by creating a new one called ‘Ebay Sales’. Save the csv file with today’s date as the filename (misali. 05.07.2014)

Ɗawainiya yi a Microsoft Word

Wadannan ayyuka da a yi a Microsoft Word sau ɗaya kawai.

Ka saita fayil ɗin kuma zabi lakabin girma.

1. Bude Microsoft Word da ajiye fayil ɗin a matsayin eBay Address Labels a cikin 'eBay Sales’ directory.
2. Zaba mailings daga shafin Ribbon toolbar
3. Select labels and choose the label that you would like to print on by clicking the options button. I recommend using J8173, wanda 10 tasirin a kan A4 sheet. When you have chosen the label of your choice click on New Document.
   
4. A cikin mailings shafin click on Zabi Recepients -> Yi amfani da data kasance List
5. Find da CSV fayil kuma latsa Open.

Add da adireshin da bayanai zuwa ga tasirin

1. Now to add the address and item information to the labels. Click on the mailings tab and choose Rules and add next record if. From the field name drop down list choose item number and click on OK. This ensures that only rows with data in the CSV are picked up in the Labels.
2. Click on Address Block in the Mailings Tab. From the insert recipient name in this format list select the first option ‘Josh’
3. A cikin kawai sun haɗa da ƙasa / yanki, idan daban-daban sama da: choose your home country. For me this would be United Kingdom.
4. Uncheck address according to country/destination checkbox. The options you have now selected should be as below.
   
5. Click on Match Fields button and map the field according to the image below.
   
   Click Ok lokacin da aikata, kuma ya kamata ka gani <<Address Block>> a kan tasirin daftarin aiki. Press enter twice to start a new line leaving a line space.
   

Add kan abun da shipping bayanai zuwa ga tasirin

1. Next shine samun abu yawa, item name and shipping service on the label. Click insert merge field and choose Quantity and then OK.Press the space bar once to leave a space.
2. Click dokoki da kuma zaɓar Idan…To,…Else. From the resulting dialog box, select field name as Item_Number and for comparison choose Not equal to and type x in the Insert this text box. Click on OK. Press the space bar once to leave a space.
3. Click insert merge field and choose Item_Title and press the space bar to leave a space.
4. Click dokoki da kuma zaɓar Idan…To,…Else. From the resulting dialog box, zaži filin sunan kamar yadda Item_Number da kuma kwatanta zabi ba daidai yake da kuma irin / in the Insert this text box. Click on OK. Press the space bar once to leave a space.
5. Click Saka ci filin da za i Delivery_Service
   

Replicate da tasirin

1. Kwafi duk filayen a cikin ta farko lakabi da manna shi a karo na biyu lakabi
2. A na biyu lakabi kawai sanya siginan kwamfuta kafin «Next Record Idan» da kuma danna dokoki da kuma zaɓar «Next Record»
3. Kwafi na «Next Record Idan» manna nan da nan bayan «Next Record Idan» sai kana da biyu.
4. Kwafi duk filayen daga filin na biyu da dukan sauran m tasirin. You may also want to change the text colors and font size.
   
5. Click on Preview Results ganin ka tasirin.
   

Here is the word file that I have created. You will need to download the CSV file with the sold item data from ebay.co.uk If this file works with other ebay sites then please leave a comment below. You might need to re-map the fields to use this file.

Download

If prompted to select the header record delimiters then choose as in the below image and then click on OK. You may be given warnings of missing data, Idan haka ne to, danna kan Ok kan kowane daga cikinsu.