Ikheli Free ilebula uhlelo wokunyathelisa for eBay Abadayisi

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) kanye quanities athumele futhi nenkonzo wemikhumbi, wakwenza wakwazi pick, iphasela bese post izinto appropiately.

Ukuze asebenzise lesi simiso wena kuzodinga Microsoft Word 2007 / 2010 / 2013 .

Okulandelayo izokubonisa indlela print address labels in Microsoft Word without the requirement for custom software.

Imisebenzi ukuyenza at ebay.co.uk

Ubungeke imisebenzi elandelayo kumele kwenziwe ebay.co.uk everytime bathanda yokunyathelisa amalebuli ezintsha ikheli.

  1. Yiya sakho badayisa ayithemu uhlu in eBay Ukuthengisela Manager (My eBay -> Ukudayisa, ke khetha UYADAYISWA kusuka kwimenyu kwesokunxele)
    ebay-sold-items
  2. Kusukela Isihlungi Isimo akhethe abalindele Dispatch
  3. Hlola zonke amabhokisi wokuhlola eduze izinto badayisa
  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 (isib. 05.07.2014)

Imisebenti ukuyenza Microsoft Word

Le misebenzi elandelayo kufanele kwenziwe Microsoft Word kanye kuphela.

Setha ifayela bese ukhetha izilinganiso zobukhulu ilebula.

  1. Vula Microsoft Word bese ugcine ifayela njengoba eBay Ikheli Labels ku 'eBay Sales’ lwemibhalo.
  2. Khetha ithebhu kutholakale kusukela yamathuluzi Ribbon
  3. Select labels and choose the label that you would like to print on by clicking the options button. I recommend using J8173, okusho ukuthi 10 amalebula on i A4 sheet. When you have chosen the label of your choice click on New Document.
    microsoft-word-label-options
  4. Esikhathini i kutholakale ithebhu on Khetha Recepients -> Sebenzisa Uhlu okhona
  5. Thola ifayela bese uchofoze CSV Vulekile.

Engeza idatha ikheli kuya amalebula

  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. In the kuphela zihlanganisa izwe / isifunda uma ehlukene kuka: 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
    Chofoza KULUNGILE uma kwenziwa futhi kufanele ubone <<Ikheli Vimbela>> on amalebula akho mbhalo. Press enter twice to start a new line leaving a line space.
    microsoft-word-address-block

Hlanganisa entweni bese idatha wemikhumbi kuya amalebula

  1. Okulandelayo ukuthola umthamo kwento, 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. Chofoza imithetho futhi akhethe Uma…Bese…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. Chofoza imithetho futhi akhethe Uma…Bese…Else. From the resulting dialog box, khetha igama emadlelweni Item_Number nangenxa ukuqhathanisa akhethe Not esilingana ne hlobo / in the Insert this text box. Click on OK. Press the space bar once to leave a space.
  5. Chofoza faka ukuhlanganisa insimu akhethe Delivery_Service
    microsoft-word-ebay-mail-merge-tutorial

Ukuphindaphinda amalebula

  1. Kopisha konke amasimu kuleli ilebula yokuqala bese unamathisele ilebula yesibili
  2. Esikhathini ilebula yesibili kuphela kwenza leli isikhombisi phambi «Next Record Ukube» bese uchofoze imithetho futhi ukhethe «Next Qopha»
  3. Kopisha i-«Next Record Ukube» unamathisele ngokushesha emva «Landelayo Record Uma» ukuze ube ezimbili.
  4. Kopisha konke amasimu evela ensimini yesibili zonke ezinye amalebula asele. You may also want to change the text colors and font size.
    microsoft-word-ebay-shipping-address-labels
  5. Chofoza Preview Umphumela ukubona amalebula akho.
    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.

Thwebula

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, uma kunjalo ke chofoza OK ngasinye sazo.

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

Shiya impendulo