Saor in Aisce seoladh córas priontála lipéad do Sellers eBay

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) agus quanities a long agus an tseirbhís loingseoireachta, ar chumas uait a phiocadh, pacáiste agus iar na míreanna appropiately.

D'fhonn úsáid a bhaint an gcóras seo beidh tú ag teastáil Microsoft Word 2007 / 2010 / 2013 .

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

Tascanna le déanamh ag ebay.co.uk

Tá na tascanna seo a leanas a dhéanamh i everytime ebay.co.uk mhaith leat a phriontáil seoladh lipéid nua.

1. Téigh go dtí do dhíol míreanna liosta i eBay Díol Bainisteoir (Mo Ebay -> Díol, ansin roghnaigh Díolta as an roghchlár ar chlé)
   
2. Ón Stádas scagaire a roghnú ag feitheamh seolta
3. Seiceáil go léir na ticbhoscaí in aice leis na nithe a dhíoltar
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 (m.sh.. 05.07.2014)

Tascanna a dhéanamh i Microsoft Word

Tá na tascanna seo a leanas a dhéanamh i Microsoft Word ach aon uair amháin.

Socraigh suas an comhad agus roghnaigh an toisí lipéad.

1. Oscail Microsoft Word agus an comhad a shábháil mar Lipéid Seoladh Ebay sa 'Díolacháin Ebay’ eolaire.
2. Roghnaigh an cluaisín mailings ón bharra uirlisí Ribbon
3. Select labels and choose the label that you would like to print on by clicking the options button. I recommend using J8173, a bhfuil 10 lipéid ar bhileog A4. When you have chosen the label of your choice click on New Document.
   
4. Sa an mailings cluaisín cliceáil ar Roghnaigh Recepients -> Úsáid atá ann cheana Liosta
5. Faigh an comhad CSV agus cliceáil Oscailte.

Cuir na sonraí seoladh chuig na lipéid

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. Sa Amháin áireamh an tír / réigiún más difriúil ná: 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.
   
   Cliceáil OK nuair a dhéanamh agus ba chóir duit a fheiceáil <<Seoladh Bloc>> ar do lipéid doiciméad. Press enter twice to start a new line leaving a line space.
   

Cuir an mír agus sonraí loingseoireachta leis na lipéid

1. Next Is é a fháil ar an méid mír, 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. Rialacha Cliceáil agus roghnaigh Má…Ansin…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. Rialacha Cliceáil agus roghnaigh Má…Ansin…Else. From the resulting dialog box, roghnaigh an t-ainm allamuigh mar Item_Number agus chun comparáid a roghnú Ní cothrom le agus cineál / in the Insert this text box. Click on OK. Press the space bar once to leave a space.
5. Cliceáil réimse merge isteach agus a roghnú Delivery_Service
   

Aithris a dhéanamh ar lipéid

1. Cóipeáil na réimsí sa chéad lipéad agus greamaigh sé isteach ar an dara lipéad
2. Sa dara lipéad a chur ach ar an cúrsóir os comhair an «Ar Aghaidh Taifead Má» agus rialacha cliceáil agus roghnaigh «Ar Aghaidh Taifead»
3. Cóipeáil an «Ar Aghaidh Taifead Má» agus greamaigh díreach tar éis «Ar Aghaidh Taifead Má» ionas go mbeidh tú dhá.
4. Cóipeáil na réimsí ar an dara réimse leis na lipéid eile atá fágtha. You may also want to change the text colors and font size.
   
5. Cliceáil ar Torthaí Réamhamhairc a fheiceáil do lipéid.
   

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.

Íosluchtaigh

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, más amhlaidh ansin cliceáil ar OK ar gach ceann acu.