donjuanjuarez
New Member
- Joined
- Feb 20, 2015
- Messages
- 1
Here is what I'm trying to do - I am with an ecommerce company and we need to export our international packages to a 3rd party for fulfillment. We create a CSV file with all orders - some orders are just individual product SKU's and other orders contain "Bundle" SKU's (which have multiple product SKU's within).
I am trying to create an automatic update so that IF there is a Bundle SKU, then Excel will automatically add rows of individual SKU's, its price, quantity and extended price.
Example 1 - our CURRENT exported order file:
<tbody>
</tbody>
Example 2 - our DESIRED order file (which should retrieve Bundle contents from another worksheet/file). This is what I'd like to try and produce, where the Order 12345 has the individual items listed out:
<tbody>
</tbody>
I am trying to create an automatic update so that IF there is a Bundle SKU, then Excel will automatically add rows of individual SKU's, its price, quantity and extended price.
Example 1 - our CURRENT exported order file:
Order Number | Box 1 | Weight | Order Date | First Name | Last Name | Address 1 | Address 2 | Address City | Address State | Address Postal Code | Address Country | SKU | Item Description | Quantity | Price | Extended Price |
12345 | Box 1 | 2 | 2/20/2015 | Don | Juan | 123 Main St | Suite 1 | San Francisco | CA | 34117 | US | BUNDLE1 | Holiday Bundle | 1 | $100 | $100 |
<tbody>
</tbody>
Example 2 - our DESIRED order file (which should retrieve Bundle contents from another worksheet/file). This is what I'd like to try and produce, where the Order 12345 has the individual items listed out:
Order Number | Weight | Order Date | First Name | Last Name | Address 1 | Address 2 | Address City | Address State | Address Postal Code | Address Country | SKU | Item Description | Quantity | Price | Extended Price |
12345 | 2 | 2/20/2015 | Don | Juan | 123 Main St | Suite 1 | San Francisco | CA | 34117 | US | BUNDLE1 | Holiday Bundle | 1 | $100 | $100 |
12345 | .5 | 2/20/15 | Don | Juan | 123 Main St | Suite 1 | San Francisco | CA | 34117 | US | Lotion101 | Lotion | 2 | $20 | $40 |
12345 | .5 | 2/20/15 | Don | Juan | 123 Main St | Suite 1 | San Francisco | CA | 34117 | US | Shamp101 | Shampoo | 2 | $20 | $40 |
12345 | 1 | 2/20/15 | Don | Juan | 123 Main St | Suite 1 | San Francisco | CA | 34117 | US | Cleaner101 | Cleaner | 1 | $20 | $20 |
12346 | 1.5 | 2/21/2015 | Jon | Doe | 111 Main St. | Nowhere | GA | 12345 | US | Lotion101 | Lotion | 3 | $20 | $60 |
<tbody>
</tbody>