You'd better say how you want map these headers:
Order ID
Email
Financial Status
Paid at
Fulfillment Status
Fulfilled at
Currency
Subtotal
Shipping
Taxes
Amount Refunded
Total
Discount Code
Discount Amount
Shipping Method
Created at
Lineitem quantity
Lineitem name
Lineitem price
Lineitem sku
Lineitem variant
Lineitem requires shipping
Lineitem taxable
Lineitem fulfillment status
Billing Name
Billing Address1
Billing Address2
Billing City
Billing Zip
Billing Province
Billing Country
Billing Phone
Shipping Name
Shipping Address1
Shipping Address2
Shipping City
Shipping Zip
Shipping Province
Shipping Country
Shipping Phone
Cancelled at
Private Notes
Channel Type
Channel Name
Channel Order Number
Product Form: Participants First Name
Product Form: Participants Last Name
Product Form: Address
Product Form: Address (Line2)
Product Form: City
Product Form: State
Product Form: Postal Code
Product Form: School
Product Form: Additional Illinois Schools
Product Form: School Grade
Product Form: Email
Product Form: Phone 1
Product Form: Phone 2
Payment Method
Payment Reference

to these:
Name
ID


Exp.
St
Gr
Team
Rate
Local

Name participants Last Name, Participants First Name
ID
Exp.
St
Gr School Grade
Team School
Rate
Local

I should have done this before. The only things I need are Participants Lane, First name in the name field, school grade in the GR field, and School in the team field (I adjusted our website, so It should be correct for our next event. All the other fields can be blank since my other program will add them in. However, even though they are blank, I need those fields to be in the sheet, or else my program will not read the file.



Thank you guys for all the help!

I might have screwed things up even more I went and adjusted our site to make it easier to register, I also adjusted the school codes so it would be the correct format. I deleted a column that screwed it up.

Here is the new download format.

I only need the following

Name participants Last Name, Participants First Name
ID
Exp.
St
Gr School Grade
Team School
Rate
Local

I should have done this before. The only things I need are Participants Lane, First name in the name field, school grade in the GR field, and School in the team field (I adjusted our website, so It should be correct for our next event. All the other fields can be blank since my other program will add them in. However, even though they are blank, I need those fields to be in the sheet, or else my program will not read the file.

Apologies for making this so hard for you guys, and thank you for all the help

Attached Files

correct format.xlsx (10.8 KB, 7 views)