Free adirẹsi aami titẹ sita eto fun awon ti o ntaa lori ibi ita oja 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) ati lati quanities omi ati awọn sowo iṣẹ, to muu o si mu, package ati ki o fí awọn ohun kan appropiately.

Ni ibere lati lo yi eto ti o yoo beere Microsoft oro 2007 / 2010 / 2013 .

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

Awọn iṣẹ-ṣiṣe lati se ni ebay.co.uk

Wọnyí awọn iṣẹ-ṣiṣe ni lati ṣee ṣe ni ebay.co.uk nigbagbogbo o yoo fẹ lati tẹ sita titun adirẹsi akole ni.

1. Lọ si akojọ awọn ohun rẹ ta ni lori ibi ita oja eBay ta Manager (Mi lori ibi ita oja eBay -> Ta, lẹhinna yan ta lati osi akojọ)
   
2. Lati Ipo àlẹmọ yan durode disipashi
3. Ṣayẹwo gbogbo awọn checkboxes tókàn si ta awọn ohun
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 (fun apẹẹrẹ. 05.07.2014)

Awọn iṣẹ-ṣiṣe lati se ni Microsoft oro

Wọnyí awọn iṣẹ-ṣiṣe ni lati ṣee ṣe ni Microsoft oro ni ẹẹkan.

Ṣeto soke faili naa ko si yan aami mefa.

1. Šii Microsoft Ọrọ ki o si fi awọn faili lori ibi ita oja eBay bi Àdírẹsì akole ni ni 'lori ibi ita oja eBay tita’ liana.
2. Yan awọn mailings taabu lati ọja tẹẹrẹ fi nlọ
3. Select labels and choose the label that you would like to print on by clicking the options button. I recommend using J8173, ti o jẹ 10 akole ni lori ohun A4 dì. When you have chosen the label of your choice click on New Document.
   
4. Ni awọn mailings taabu lẹmeji lori Yan Recepients -> Lo wa tẹlẹ Akojọ
5. Wa awọn CSV faili ki o si tẹ Ši.

Fi adirẹsi data lati awọn akole ni

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. Ni awọn nikan ni awọn orilẹ-ede / agbegbe ti o ba ti yatọ si ju: 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.
   
   Nigbati o tẹ O dara ṣe ati o yẹ ki o ri <<Adirẹsi dènà>> lori rẹ akole ni iwe-ipamọ. Press enter twice to start a new line leaving a line space.
   

Fi awọn ohun kan ati ki o sowo data si akole ni

1. Tókàn ni lati gba awọn ohun kan opoiye, 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. Tẹ awọn ofin ati ki o yan Ti…Nigbana…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. Tẹ awọn ofin ati ki o yan Ti…Nigbana…Else. From the resulting dialog box, yan awọn aaye orukọ bi Item_Number ati fun lafiwe yan Ko si dogba lati ati si iru / in the Insert this text box. Click on OK. Press the space bar once to leave a space.
5. Tẹ ti fi dapọ aaye ati ki o yan Delivery_Service
   

Tun ṣe ni akole ni

1. Da gbogbo awọn aaye ni akọkọ aami ati ki o lẹẹmọ o si sinu awọn keji aami
2. Ni awọn keji aami nikan fi kọsọ ṣaaju ki awọn «Next Gba Ti» ki o si tẹ awọn ofin ati ki o yan «Next Gba»
3. Da awọn «Next Gba Ti» ati ki o lẹẹmọ lẹsẹkẹsẹ lẹhin «Next Gba Ti» bẹ o ni meji.
4. Da gbogbo awọn aaye lati awọn aaye keji si gbogbo awọn miiran ti o ku akole ni. You may also want to change the text colors and font size.
   
5. Tẹ lori akọwo esi lati ri rẹ akole ni.
   

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, ti o ba ti bẹ ki o si tẹ O dara lori lori kọọkan ti wọn.