Enderezo Libre sistema de impresión de etiquetas para Vendedores de 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) e quanities para enviar e do servizo de transporte, permitindo que escolla, embalar e enviar os elementos appropiately.

Para usar este sistema vai esixir o Microsoft Word 2007 / 2010 / 2013 .

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

Tarefas para facer na ebay.co.uk

As tarefas a seguir ten que ser feito en ebay.co.uk cada vez que quere imprimir novas etiquetas de enderezo.

1. Vaia á súa lista de elementos vendidos en eBay Selling Xerente (My Ebay -> Venda, a continuación, escolla Vendido no menú da esquerda)
   
2. Do filtro Estado escoller agardando envío
3. Consulte todas as caixas de verificación ao lado dos elementos vendidos
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)

Tarefas para facer en Microsoft Word

As tarefas a seguir ten que ser feito en Microsoft Word só unha vez.

Configure o arquivo e escoller as dimensións da etiqueta.

1. Abre o Microsoft Word e gardar o ficheiro como etiquetas de enderezo no Ebay das vendas Ebay’ directorio.
2. Escolla o separador mailings da barra de ferramentas cinta
3. Select labels and choose the label that you would like to print on by clicking the options button. I recommend using J8173, que é 10 etiquetas nunha folla A4. When you have chosen the label of your choice click on New Document.
   
4. Na guía Correspondencias, prema Seleccionar recepients -> Usar Lista Existente
5. Localice o ficheiro CSV e prema en Abrir.

Engadir os datos de enderezo para as etiquetas

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. O único incluír o país / rexión, de ser diferente do que: 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.
   
   Prema en Aceptar cando remate e ten que ver <<Bloque de Dirección>> no seu documento etiquetas. Press enter twice to start a new line leaving a line space.
   

Engadir o elemento e datos de navegación para as etiquetas

1. A continuación é a de obter a cantidade do elemento, 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. Prema regras e elixir Se…Despois…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. Prema regras e elixir Se…Despois…Else. From the resulting dialog box, seleccione o nome do campo como item_number e para comparación escoller Non igual a e escriba / in the Insert this text box. Click on OK. Press the space bar once to leave a space.
5. Prema campo de mesclagem de inserción e escolle Delivery_Service
   

Duplicar as etiquetas

1. Copia todos os campos na primeira etiqueta e pega o no segundo etiqueta
2. Na segunda etiqueta só poñer o cursor antes do «Seguinte Rexistro Se» e prema normas e escoller «Seguinte Rexistro»
3. Pega o «Seguinte Rexistro Se» e pega inmediatamente despois «Seguinte Rexistro Se» para que teña dous.
4. Copia todos os campos desde o segundo campo para todas as outras etiquetas restantes. You may also want to change the text colors and font size.
   
5. Prema Eventos Resultados para ver os seus rótulos.
   

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.

Descargar

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, Se si, entón faga clic en Aceptar en cada un deles.