Dawb chaw nyob daim ntawv lo printing system rau eBay Sellers

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) thiab quanities rau nkoj thiab cov kev pab cuam shipping, enabling koj tsaws, pob thiab post rau tej yam khoom uas appropiately.

Yuav kom siv tau no system koj yuav yuav tsum tau Microsoft Word 2007 / 2010 / 2013 .

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

Paub tab mus ua nyob rau ntawm ebay.co.uk

Cov nram qab no paub tab yuav tsum tau ua nyob rau hauv ebay.co.uk everytime koj xav luam qhov chaw nyob tshiab daim ntawv.

1. Mus rau koj muag cov khoom nyob rau hauv daim ntawv teev eBay Muag Manager (Kuv eBay -> Muag, ces xaiv Muag los ntawm cov ntawv qhia zaub mov rau sab laug)
   
2. Los ntawm lub Status lim xaiv tab tom tos tso
3. Kos tag nrho cov lub checkboxes tom ntej mus rau lub muag khoom
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 (piv txwv li. 05.07.2014)

Yam ua nyob rau hauv Microsoft Word

Cov nram qab no paub tab yuav tsum tau ua nyob rau hauv Microsoft Word tsuas yog ib zaug.

Teem cov ntaub ntawv thiab xaiv daim ntawv lo rau qhov ntev.

1. Qhib Microsoft Word thiab txuag tau cov ntaub ntawv raws li ebay Chaw nyob daim ntawv nyob rau hauv lub 'eBay Muag’ directory.
2. Xaiv qhov mailings tab los ntawm cov 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, uas yog 10 daim ntawv lo rau ib daim ntawv A4. When you have chosen the label of your choice click on New Document.
   
4. Nyob rau hauv lub mailings tab nias rau Xaiv Recepients -> Siv uas twb muaj List
5. Nrhiav tus CSV cov ntaub ntawv thiab nias Qhib.

Ntxiv rau qhov chaw nyob ntaub ntawv mus rau cov daim ntawv

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. Nyob rau hauv lub Tsuas yog muaj xws li hauv lub teb chaws / cheeb tsam yog tias txawv tshaj: 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.
   
   Nias OK thaum ua thiab koj yuav tsum pom <<Chaw nyob Block>> nyob rau hauv koj daim ntawv lo daim ntawv. Press enter twice to start a new line leaving a line space.
   

Ntxiv qhov khoom thiab shipping cov ntaub ntawv mus rau daim ntawv lo

1. Next yog kom tau yam khoom ntawd ntau, 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. Nyem kev cai thiab kev xaiv Yog hais tias…Ces…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. Nyem kev cai thiab kev xaiv Yog hais tias…Ces…Else. From the resulting dialog box, xaiv teb lub npe raws li Item_Number thiab rau kev sib piv xaiv Tsis vaj huam sib luag rau thiab hom / in the Insert this text box. Click on OK. Press the space bar once to leave a space.
5. Nyem insert merge teb thiab xaiv Delivery_Service
   

Replicate lub daim ntawv lo

1. Luam tag nrho cov teb nyob rau hauv thawj daim ntawv lo thiab muab tshuaj txhuam nws mus rau hauv ob daim ntawv lo
2. Nyob rau hauv ob daim ntawv lo tsuas yog muab tso rau lub cursor ua ntej «Next Ntaub Yog» thiab nias cov kev cai thiab xaiv «Next Ntaub»
3. Luam lub «Next Ntaub Yog» thiab muab tshuaj txhuam tam sim ntawd tom qab «Next Ntaub Yog» yog li ntawd koj muaj ob.
4. Luam tag nrho lub teb los ntawm ob teb rau tag nrho cov lwm yam tshuav daim ntawv. You may also want to change the text colors and font size.
   
5. Nyem rau preview tau mus ntsib koj tus daim ntawv.
   

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, yog hais tias yog li ntawd ces nias rau OK rau txhua yam uas lawv.