Free indirizz tikketta istampar sistema għall Bejjiegħa 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(i) u quanities għall-vapur u s-servizz tat-tbaħħir, li jippermetti li inti pick, pakkett u post l-oġġetti appropiately.

Sabiex jużaw din is-sistema tkun teħtieġ Microsoft Word 2007 / 2010 / 2013 .

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

Kompiti li tagħmel fid ebay.co.uk

Il-kompiti li ġejjin jkollu jsir fil everytime ebay.co.uk inti tixtieq li jistampaw indirizz tikketti ġodda.

1. Mur mibjugħa oġġetti lista tiegħek eBay Bejgħ Manager (EBay tiegħi -> Bejgħ, imbagħad jagħżlu Mibjugħ mill-menu tax-xellug)
   
2. Mill-filtru Status tagħżel jistennew dispaċċ
3. Iċċekkja l-checkboxes li jmiss għall-oġġetti mibjugħa
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 (eg. 05.07.2014)

Kompiti li jagħmlu fil-Microsoft Word

Il-kompiti li ġejjin jkollu jsir fil-Microsoft Word darba biss.

Twaqqaf il-fajl u jagħżlu l-qisien tat-tikketta.

1. Open Microsoft Word u jiffrankaw l-fajl bħala eBay Labels indirizz fl-"Bejgħ eBay’ direttorju.
2. Agħżel il-tab mailings mill-toolbar żigarella
3. Select labels and choose the label that you would like to print on by clicking the options button. I recommend using J8173, li huwa 10 tikketti fuq karta A4. When you have chosen the label of your choice click on New Document.
   
4. Fil-ikklikkja mailings tab fuq Recepients Agħżel -> Uża lista eżistenti
5. Sib il-fajl CSV u kklikkja Open.

Iżżid l-informazzjoni l-indirizz għall-tikketti

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. Fl-unika tinkludi lill-pajjiż / reġjun jekk differenti minn: 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.
   
   Ikklikkja OK meta jsir u inti għandek tara <<Blokk indirizz>> fuq dokument tikketti tiegħek. Press enter twice to start a new line leaving a line space.
   

Żid il-partita u data tat-tbaħħir għat-tikketti

1. Li jmiss huwa li tikseb l-kwantità oġġett, 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. Ikklikkja regoli u jagħżlu Jekk…Imbagħad…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. Ikklikkja regoli u jagħżlu Jekk…Imbagħad…Else. From the resulting dialog box, tagħżel isem tal-field bħala Item_Number u għall-paragun jagħżlu Mhux daqs u t-tip / in the Insert this text box. Click on OK. Press the space bar once to leave a space.
5. Ikklikkja qasam jingħaqdu daħħal u jagħżlu Delivery_Service
   

Replikata-tikketti

1. Ikkopja l-oqsma kollha fl-ewwel tikketta u paste fil-tieni tikketta
2. Fit-tieni tikketta biss tpoġġi l-cursor qabel l-«jmiss Record Jekk» u kklikkja regoli u jagħżlu «Record jmiss»
3. Ikkopja l-"Next Record Jekk» u paste immedjatament wara «jmiss Record Jekk» hekk ikollok żewġ.
4. Ikkopja l-oqsma kollha mit-tieni qasam li l-tikketti l-oħra li jifdal. You may also want to change the text colors and font size.
   
5. Ikklikkja fuq Riżultati Preview biex tara tikketti tiegħek.
   

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, jekk hekk allura ikklikkja fuq OK fuq kull wieħed minnhom.