Free helbide etiketa inprimatzeko Ebay Sellers sistema

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(z) eta quanities ontziratu eta bidalketa zerbitzua, hautatzeko aukera ematen dizu, pakete eta elementuak appropiately bidaltzeko.

Sistema hau erabili ahal izateko Microsoft Word behar dituzu 2007 / 2010 / 2013 .

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

Lanei ebay.co.uk egin

Zeregin hauek izan ebay.co.uk Beti egin behar helbideen etiketa berria inprimatu nahi dituzun.

  1. Zure saldu elementuak eBay Salmenta Kudeatzaile zerrenda joan (Nire Ebay -> Saltzen, ondoren, aukeratu ezkerreko menuan Agortuta)
    ebay-sold-items
  2. Egoera iragazkia aukeran bidalketa zain
  3. Check karratuak guztiak saldu elementuak ondoan
  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 (adibidez. 05.07.2014)

Lanei Microsoft Word-en egin

Zeregin hauek izan Microsoft Word egin behar behin bakarrik.

Konfiguratu fitxategia eta etiketa dimentsioak aukeratu.

  1. Ireki Microsoft Word eta gorde fitxategia Ebay Helbidea the 'Ebay salmentak Labels gisa’ directory.
  2. Aukeratu mezuak fitxan Zinta tresna barran
  3. Select labels and choose the label that you would like to print on by clicking the options button. I recommend using J8173, hau da, 10 A4 orri bat on labels. When you have chosen the label of your choice click on New Document.
    microsoft-word-label-options
  4. Mailing fitxa Aukeratu Recepients klik batean -> Dauden zerrenda
  5. Aurkituko CSV fitxategia eta egin klik Ireki.

Gehitu helbide datuen etiketak egiteko

  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. Bakarrik, besteak beste, herrialde / eskualde baino desberdina bada: 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.
    microsoft-word-insert-address-block-map-address-to-CSV-header-names-fields
  5. Click on Match Fields button and map the field according to the image below.
    microsoft-word-mail-merge-match-fields-map-to-CSV-header
    Sakatu Ados egindakoan eta ikusi behar duzu <<Helbide Bloque>> Zure labels dokumentu on. Press enter twice to start a new line leaving a line space.
    microsoft-word-address-block

Gehitu elementua eta bidalketa datuen etiketak egiteko

  1. Hurrengoa da elementua kantitatea lortzeko, 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. Ezkutatu arauak eta aukeratzen bada…Ondoren…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. Ezkutatu arauak eta aukeratzen bada…Ondoren…Else. From the resulting dialog box, hautatu eremua izena Item_Number gisa eta konparatzeko aukeratzen Not berdina eta mota / in the Insert this text box. Click on OK. Press the space bar once to leave a space.
  5. Ezkutatu txertatze merge eremua eta aukeratu Delivery_Service
    microsoft-word-ebay-mail-merge-tutorial

Etiketak errepikatzeko

  1. Kopiatu lehen etiketa eremu guztiak eta itsatsi bigarren etiketa sartu
  2. Bigarren etiketa bakarrik jarri kurtsorea aurretik «Hurrengo grabatu bada» eta klikatu arauak eta aukeratu «Hurrengo grabatu»
  3. Kopiatu «Hurrengo grabatu bada» eta itsatsi berehala «Hurrengo grabatu bada» ondoren, beraz, bi aukera izango duzu.
  4. Kopiatu eremu guztiak bigarren eremutik gainerako etiketa guztiak egiteko. You may also want to change the text colors and font size.
    microsoft-word-ebay-shipping-address-labels
  5. Click on Aurreikusi emaitzak zure labels ikusteko.
    microsoft-word-ebay-shipping-address-labels-preview

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.

Jaitsi

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, beraz, ondoren egin klik Ados bada horietako bakoitzean on.

microsoft-word-mail-merge-header-record-delimiters

Utzi erantzuna