Difference between revisions of "pickPack Setup"

From Moogento How-to Guides
Jump to navigation Jump to search
m
m
Line 103: Line 103:
 
#* This will have a column title of 'Column Name 1' and will show values from the magento order attribute <code>magento_order_attribute_here</code>.
 
#* This will have a column title of 'Column Name 1' and will show values from the magento order attribute <code>magento_order_attribute_here</code>.
 
#:<code>Column Name 2:[fixed text here];</code>
 
#:<code>Column Name 2:[fixed text here];</code>
#* This will have a column title of 'Column Name 2' and will have in every cell 'fixed text here'</code>.
+
#* This will have a column title of 'Column Name 2' and will have in every cell <code>fixed text here</code>.
 
#:<code>Column Name 3:%magento_order_attribute_here% %another_magento_order_attribute_here%;</code>
 
#:<code>Column Name 3:%magento_order_attribute_here% %another_magento_order_attribute_here%;</code>
 
#* This will have a column title of 'Column Name 3' and will show combined values from the magento order attributes <code>magento_order_attribute_here</code> and <code>another_magento_order_attribute_here</code>.
 
#* This will have a column title of 'Column Name 3' and will show combined values from the magento order attributes <code>magento_order_attribute_here</code> and <code>another_magento_order_attribute_here</code>.
Line 198: Line 198:
 
#* ''eg. color, size, your_custom_product_attribute.''
 
#* ''eg. color, size, your_custom_product_attribute.''
 
#:<code>Column Name 2:[fixed text here];</code>
 
#:<code>Column Name 2:[fixed text here];</code>
#* This will have a column title of 'Column Name 2' and will have in every cell 'fixed text here'</code>.
+
#* This will have a column title of 'Column Name 2' and will have in every cell <code>fixed text here</code>.
 
#:<code>Column Name 3:%magento_special_attribute%;</code>
 
#:<code>Column Name 3:%magento_special_attribute%;</code>
 
#* This will have a column title of 'Column Name 3' and will show the value from the 'special' order attributes <code>magento_special_attribute</code>.
 
#* This will have a column title of 'Column Name 3' and will show the value from the 'special' order attributes <code>magento_special_attribute</code>.

Revision as of 07:32, 8 May 2014

PickPack Magento Advanced PDFs.pngGet pickPack today

Aims & Preparation

Most of this is included if you get the Installation & Setup Service

We're going to get into the meat of pickPack here, and have a quick overview of setting up its options.

We'll also setup exporting order info via csv.

Follow the Easy Install Guide & pickPack: Quickstart to get pickPack up and running.

 

Customising PDF Invoice & Packing Sheet

The end result is the ability to customise output to suit your unique business.

Set these in SystemConfigMoogento > pickPack > PDF Packing Sheets / PDF Invoices (some of these options can also be set in the Picklist and CSV sections).

Integrated Labels

If you're printing addresses on Integrated Labels, this is an important step. If you're not sure what this is, I really recommend having a google, printing orders on integrated labels saved our product business literally hours every week, but more importantly made it a lot more organised - you have everything you need for the order in your hand. By the way we manufacture integrated labels ourselves and can do a good deal - drop us a line.

  1. First up, turn on the shipping address: Add shipping address at bottom? > Yes and have a test print.
  2. You'll also see Nudge shipping address - you can use this to precisely position the address on your integrated label.
  3. Other notable sections here:
    • Show order ID above address? - useful for when you have packed your orders, you can quickly see which order is which (eg. if the customer requests a last-minute change; or just to quickly work out which orders you have shipped).
    • Add Order ID barcode? - you can then automate actions using shipEasy. Eg. as you send each parcel out the door you can set the status to 'shipped', email the customer, and apply a custom tag for the shipment group (all in the time it takes to press the barcode scanning button).
    • Add return address at bottom? - if you're making life easy and print the return address in the same integrated sheet, turn this one on.
You should now have integrated labels printing direct from Magento!

Product Images

Adding product images to the Packing Sheets can look good, it depends on your branding. Adding them to Picklists can help reduce picking mistakes. Turn this on in the config:

magento product images in packing sheet.png
  • To remove image borders, set the color to #FFFFFF

Shelving / Custom Product Attributes

  • Show shelving info per product = win for packing efficiency.
  • Sort product list by shelving = bonus points (save zig-zagging through the shelves).
  • Or show other custom product attributes.

Let's set this up. The procedure is approx the same for all PDFs.

  1. Find the correct attribute code - if you're not sure, check it in CatalogAttributesManage Attributes
    eg. here our correct code is shelf (case is important):shelf code.png
    • If you haven't saved shelving info for your products yet, you'll need to:
    1. Create a new attribute and
    2. Assign it to your product groups, and then
    3. Save a value for each product to the Catalog.
  2. Find the Custom attribute and set to Yes
  3. Enter the correct attribute code in there, and choose an 'X Pos' (the left-right position of this column in the PDF).

Product Name

You can change what is shown for the product name in a couple of important ways.

  • Show configurable product name instead of simple product name.
Use this for example to show 'Socks' instead of 'Red Socks Small Women's PCW2849211'.
  • Pull the name attribute from the default store, instead of the selling store.
If your warehouse operates in a different language to your customers this helps to avoid packing mistakes.
  • Choose to word-wrap instead of trim a long product name.
Trimmed usually looks better, but some setups need the full name to pack correctly.
custom product name.png


Address Labels

Print a sheet with all shipping addresses.

  • Add in order ID barcodes, return addresses.
  • Customize label padding and margins to suit your label sheets.

Warehouse/Shipping Printouts

pickPack has a wide range of PDF and CSV outputs available, to integrate Magento with your packing setup - whether that's a large warehouse, or your garage! These are all fairly self-explanatory to setup, but quick overviews follow.

  • On the PDFs, you can show up to two tickboxes per line item (handy for packing and checking).
  • You can also set it to show the product SKUs as barcodes.

PDF Order-Combined Picklists

These are a great way to get the sum total of what has been ordered for a select group of orders.

  • In the config section you can choose to show the total-cost/total-paid/total-shipping.
    • This can be useful to work out profit/loss on a group of orders.
    • Alternatively if you are dropshipping, or purchasing these items from outside suppliers, you can work out what you'll need to pay them.

PDF Order-Separated Picklists

A nice simple way to get an overview of what has been ordered, what needs picking, shipping method chosen, etc.

  • In the config section you can turn on order ID and product barcodes, shipping addresses and methods, and show extra product attributes.
  • You can also set it to show out of stock items.

PDF Orders Summary

Similar to the Order-Separated Picklist, this can also show totals paid for each order, including taxable and zero-rated totals.

  • You can also add barcodes, so at the end of the day you can quickly reselect relevant orders for further processing with shipEasy.
  • This is useful for entering orders into accounts.

PDF Out-of-Stock Picklists

If you're buying in products from outside suppliers, or need a quick overview of which items need ordering from the factory, this will show a list of only those items which are out-of-stock in selected orders.

  • You can set what qty to consider out of stock.
  • You can configure it to show a custom attribute (eg. shelf).

CSV Exports

These are very powerful, very customisable, but also very simple-to-setup options.

CSV Orders Export

  • This will output one line per selected order, in a CSV file.
  • You can include order summary info in this csv, such as:
    • Shipping/billing addresses
    • Customer name (and the parts if needed)
    • Amount paid
    • Date of order

Format

  1. Enter into the large text box one line per column which you'd like to generate in the CSV.
  2. Use this format:
    Column Name 1:%magento_order_attribute_here%;
    • This will have a column title of 'Column Name 1' and will show values from the magento order attribute magento_order_attribute_here.
    Column Name 2:[fixed text here];
    • This will have a column title of 'Column Name 2' and will have in every cell fixed text here.
    Column Name 3:%magento_order_attribute_here% %another_magento_order_attribute_here%;
    • This will have a column title of 'Column Name 3' and will show combined values from the magento order attributes magento_order_attribute_here and another_magento_order_attribute_here.
  3. Use the 'magento order attribute' from the list below.
  4. %ship-address% and %bill-address% are slightly special, they combine the entire address into one field, and you can set the order and contents of the address particles in the separate options box for that.

Options

Order Info

%order_id% %order_status% %order_subtotal% %order_tax_amount% %warehouse% %grand_total% %order_date% %qty_items% %website% %customer_id% %newsletter_subscription_status%

Order Weight

%weight% : total weight as entered (eg '120')
%weight_kg_suffix% : total weight with 'kg' text suffixed (eg '120 kg')
%weight_lb_suffix% : total weight with 'lb' text suffixed (eg '120 lb')
%weight_kg_to_lb% : total weight converted from kg to lb (eg '264.55')
%weight_lb_to_kg% : total weight converted from lb to kg (eg '54.43')
%weight_kg_to_lb_suffix% : total weight converted from kg to lb with 'lb' text suffixed (eg '264.55 lb')
%weight_lb_to_kg_suffix% : total weight converted from lb to kg with 'kg' text suffixed (eg '54.43 kg')

Billing Info

%bill_address% %bill_prefix% %bill_firstname% %bill_lastname% %bill_suffix% %bill_fullname% %bill_company% %bill_streets% %bill_street1% %bill_street2% %bill_city% %bill_region% %bill_postcode% %bill_country% %bill_country_code% %bill_telephone% %bill_email% %payment_method%

Shipping Info

%ship_address% %ship_prefix% %ship_firstname% %ship_lastname% %ship_suffix% %ship_fullname% %ship_company% %ship_streets% %ship_street1% %ship_street2% %ship_city% %ship_region% %ship_postcode% %ship_country% %ship_country_code% %ship_telephone% %ship_email% %ship_method% %shipping_paid%

Special Info

%shipping_description_filtered% %ship_service_filtered% %billing_option_filtered% %bill_non_us% %ship_non_us%

CSV Order-Separated Export

  • This will output one line per ordered SKU per selected order in a CSV file.
    eg. same sku ordered in 2 orders will appear on two lines.
  • You can include product details and some order info in this csv, such as:
    • Shipping/billing addresses
    • Customer name (and the parts if needed)
    • Amount paid
    • Date of order
    • Price of item
    • SKU, product name, options chosen
    • Gift messages

Format

  1. Enter into the large text box one line per column which you'd like to generate in the CSV.
  2. Use this format:
    Column Name 1:magento_standard_product_attribute;
    • This will have a column title of 'Column Name 1' and will show values from the magento product attribute magento_standard_product_attribute.
    • eg. color, size, your_custom_product_attribute.
    Column Name 2:[fixed text here];
    • This will have a column title of 'Column Name 2' and will have in every cell fixed text here.
    Column Name 3:%magento_special_attribute%;
    • This will have a column title of 'Column Name 3' and will show the value from the 'special' order attributes magento_special_attribute.
  3. Use the 'special attribute' from the list below.

Options

Order Info

%order_id% %order_date% %order_date_plus48h% %website% %order_subtotal% %order_status% %order_tax_amount% %order_price% %order_qty% %comment%

Customer Details

%customer_id% %bill-firstname% %bill-lastname% %bill-companyname% %bill-street1% %bill-street2% %bill-city% %bill-region% %bill-postcode% %bill-country% %bill-non-us% %bill-telephone% %bill-email% %ship-firstname% %ship-lastname% %ship-companyname% %ship-street1% %ship-street2% %ship-city% %ship-region% %ship-postcode% %ship-country% %ship-non-us% %ship-telephone% %ship-email% %shipping_address%

Product Details

%sku% %qty% %product_name% %sku_price% %total_price% %unit_price% %short_description% %product_description% %description% %gift_messages%

CSV Order-Combined Export

  • This will output one line per unique SKU from all selected orders, in a CSV file.
    eg. same sku ordered in 2 orders will appear on one lines.
  • You can include product details in this csv, such as:
    • Cost of item
    • SKU, product name, options chosen

Format

  1. Enter into the large text box one line per column which you'd like to generate in the CSV.
  2. Use this format:
    Column Name 1:magento_standard_product_attribute;
    • This will have a column title of 'Column Name 1' and will show values from the magento product attribute magento_standard_product_attribute.
    • eg. color, size, your_custom_product_attribute.
    Column Name 2:[fixed text here];
    • This will have a column title of 'Column Name 2' and will have in every cell fixed text here.
    Column Name 3:%magento_special_attribute%;
    • This will have a column title of 'Column Name 3' and will show the value from the 'special' order attributes magento_special_attribute.
  3. Use the 'special attribute' from the list below.

Options

Product Details

%sku% %qty% %product_name% %average_unit_cost% %total_cost% %unit_price% %total_price% %short_description% %product_description% %description% %product_category%