R&R Sheet:

To indicate the QTY should be DEDUCTED from Inventory

Examples for uses:
- Sending out an order for a "swapped".
- Customer wants an extra item (though we would usually create a new order using our website system rather then enter an order directly into the R&R).

eBaySale

- Copy Customer/Order information from Column C to G (eBaySales)
- Paste in Column A (R&R)
- Enter appropriate QTY
- Enter appropriate SKU
- Copy / Enter SKU (ProductCode)
- Enter SO as the "Type1" (ColumnH)
- Enter Postage Method (upgrade to X sometimes if urgent or angry customer)
- Place "T" in ToPost (yellow background)
- Copy in AUD into Column R

IF a return satchel is required
- Enter code:

500g-rtn-sat - if <500g
3kg-rtn-sat - if >500g, <3kg
Contact Manager- >3kg

- Find the Websale order
- Place a "T" in the ToPost column (Websales)
- Run "Process Sales" (Sales Processor)
- Find and copy the address data in the (MailMerge)
- Enter the address into Column B (R&R)
- Copy the Email - Column BM (Websales) to Column A (R&R)
- Copy Name from address into Column C
- Copy OrderID (from Websales) into Column D and E
- Enter appropriate QTY
- Enter appropriate SKU
- Enter SO as the "Type1" (ColumnH)
- Enter Postage Method (upgrade to X sometimes if urgent or angry customer)
- Place "T" in ToPost (yellow background)
- Copy in AUD into Column R

IF a return satchel is required
- Enter code:

500g-rtn-sat - if <500g
3kg-rtn-sat - if >500g, <3kg
Contact Manager- >3kg

To indicate the QTY should NOT be DEDUCTED from Inventory (as the QTY is counted in the original order)

eBaySale

- Copy Customer/Order from Column C to G (eBaySales)
- Paste in Column A (R&R)
- Enter appropriate QTY
- Copy / Enter SKU (ProductCode)
- Enter OI as the "Type1" (ColumnH)
- Enter Postage Method (upgrade to X sometimes if urgent or angry customer)
- Place "T" in ToPost (yellow background)
- Copy in AUD into Column R

IF a return satchel is required
- Enter code:

500g-rtn-sat - if <500g
3kg-rtn-sat - if >500g, <3kg
Contact Manager- >3kg

- Find the Websale order
- Place a "T" in the ToPost column (Websales)
- Run "Process Sales" (Sales Processor)
- Find and copy the address data in the (MailMerge)
- Enter the address into Column B (R&R)
- Copy the Email - Column BM (Websales) to Column A (R&R)
- Copy Name from address into Column C
- Copy OrderID (from Websales) into Column D and E
- Enter appropriate QTY
- Copy / Enter SKU (ProductCode)
- Enter OI as the "Type1" (ColumnH)
- Enter Postage Method (upgrade to X sometimes if urgent or angry customer)
- Place "T" in ToPost (yellow background)
- Copy in AUD into Column R

IF a return satchel is required
- Enter code:

500g-rtn-sat - if <500g
3kg-rtn-sat - if >500g, <3kg
Contact Manager- >3kg

To indicate the QTY should be DEDUCTED from Inventory

eBaySale

- Copy Customer/Order information from Column C to G (eBaySales)
- Paste in Column A (R&R)
- Enter appropriate QTY
- Copy / Enter SKU (ProductCode)
- Enter RP as the "Type1" (ColumnH)
- Enter Postage Method (upgrade to X sometimes if urgent or angry customer)
- Place "T" in ToPost (yellow background)
- Copy in AUD into Column R

IF a return satchel is required
- Enter code:

500g-rtn-sat - if <500g
3kg-rtn-sat - if >500g, <3kg
Contact Manager- >3kg

- Find the Websale order
- Place a "T" in the ToPost column (Websales)
- Run "Process Sales" (Sales Processor)
- Find and copy the address data in the (MailMerge)
- Enter the address into Column B (R&R)
- Copy the Email - Column BM (Websales) to Column A (R&R)
- Copy Name from address into Column C
- Copy OrderID (from Websales) into Column D and E
- Enter appropriate QTY
- Copy / Enter SKU (ProductCode)
- Enter RP as the "Type1" (ColumnH)
- Enter Postage Method (upgrade to X sometimes if urgent or angry customer)
- Place "T" in ToPost (yellow background)
- Copy in AUD into Column R

IF a return satchel is required
- Enter code:

500g-rtn-sat - if <500g
3kg-rtn-sat - if >500g, <3kg
Contact Manager- >3kg

- Copy Customer/Order information from from the eBaysale or Websales sheet, to create the data for Columns A to G (Use your inititve, based on what is stated above)

Note, the Address data does not affect or used in a Refund record, so no need to enter the full address if a Websale. But you must enter at least some value.

Note. the ProductCode and QTY are not affect or used in a Refund record, but should be used to indicate what we are refunding for.

- Enter RF as the "Type1" (ColumnH)
- Place the Refund total value into ColumnM.
- Place the account code for the account the refund is coming from into ColumnN (e.g. P, I)
- Copy in AUD into Column R

- Facilitate the Refund

- Copy Customer/Order information from from the eBaysale or Websales sheet, to create the data for Columns A to E (Use your inititve, based on what is stated above)

Note, the Address data does not affect or used in a Returns record, so no need to enter the full address if a Websale. But you must enter at least some value.

- Enter appropriate QTY
- Copy / Enter SKU (ProductCode)
- Enter RT as the "Type1" (ColumnH)
- Enter the date returned to us, into ColumnL
- Copy in AUD into Column R

- Copy Customer/Order information from from the eBaysale or Websales sheet, to create the data for Columns A to G (Use your inititve, based on what is stated above)

Note, the Address data does not affect or used in a Refund record, so no need to enter the full address if a Websale. But you must enter at least some value.

Note. the ProductCode and QTY are not affect or used in a Refund record, but should be used to indicate what we are refunding for.

- Enter EP as the "Type1" (ColumnH)
- Place the Payment total value into ColumnO.
- Place the account code for the account the payment is coming from into ColumnN (e.g. P, I)
- Copy in AUD into Column R