Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

throws Compile Error: sub or Function not defined #34

Open
cstocksd opened this issue Aug 30, 2021 · 0 comments
Open

throws Compile Error: sub or Function not defined #34

cstocksd opened this issue Aug 30, 2021 · 0 comments

Comments

@cstocksd
Copy link

Excel O365 VBA
Imported Jsonconverter.bas, Imported Dictionary.cls
Reference add for MS Runtime scripting

Can see data in my .ResponseText, but as soon as the program calls "Set Json = JsonConverter.ParseJson(http.responseText)", I get the compile error.

My first go around with parsing JSON data... do I need to do anything with the Dictionary other than importing it? Is there ANY reference to it in the main sub() of my script? Code is below. Error Function is below that and http.responsetext is below that

Sure appreciate the help on the (i'm sure) very simple fix to my error. Learning a lot with this 1st time parsing project :=)

Sub getdata()
Dim inJson As Object
Dim ws As Worksheet: Set ws = Worksheets("Sheet1")
Dim http As Object
Set http = CreateObject("WinHttp.WinHttprequest.5.1")
Url = "https://www.printavo.com/api/v1/orders?email=info%40magsmonograms.com&token=UNlIykfMAuTEaghEtR0KGg" & "&query=1005"
http.Open "Get", Url, False
http.send
Set Json = JsonConverter.ParseJson(http.responseText)
Stop
.
.
.
End Sub

===.> error get thrown and highlights the first "Set" statement after the : (never gets to the Stop)

Public Function ParseJson(ByVal JsonString As String) As Object
Stop
Dim json_Index As Long
json_Index = 1

' Remove vbCr, vbLf, and vbTab from json_String
JsonString = VBA.Replace(VBA.Replace(VBA.Replace(JsonString, VBA.vbCr, ""), VBA.vbLf, ""), VBA.vbTab, "")

json_SkipSpaces JsonString, json_Index
Select Case VBA.Mid$(JsonString, json_Index, 1)
Case "{"
    **_Set ParseJson = json_ParseObject(JsonString, json_Index)_**
Case "["
    Set ParseJson = json_ParseArray(JsonString, json_Index)
Case Else
    ' Error: Invalid JSON string
    Err.Raise 10001, "JSONConverter", json_ParseErrorMessage(JsonString, json_Index, "Expecting '{' or '['")
End Select

End Function

/////\ -- FYI
http.response.text = ? http.responsetext
{"meta":{"page":1,"per_page":25,"total_count":531,"total_pages":22},"data":[{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4902516,"user_id":37796,"orderstatus_id":185896,"public_hash":"a995e8b4d28ae3a530f53b0a62430e69","production_notes":"","order_nickname":"Augusta Shirts","approved":false,"approved_name":null,"visual_id":20535,"stats":{"paid":false},"notes":"","created_at":"2021-08-26T16:19:16.309-04:00","updated_at":"2021-08-29T15:09:56.930-04:00","due_date":"2021-08-26T10:00:00.000-04:00","order_total":71.0575,"order_subtotal":66.1,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"James Wilson","first_name":"James","last_name":"Wilson","company":"","email":"jxwilson1011@gmail.com","customer_id":0},"order_addresses_attributes":[{"id":20803016,"name":"Customer Billing","customer_name":"James Wilson","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":
"US","zip":""},{"id":20803017,"name":"Customer Shipping","customer_name":"James Wilson","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Quote","color":"#47A0D9"},"user":{"name":"Chic"},"lineitems_attributes":[{"id":28200912,"style_description":"Augusta Sportswear - Adult Attain Wicking Short-Sleeve T-Shirt","taxable":true,"style_number":"2790","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":3,"total_quantities":3,"goods_status":"","category":" 3-Apparel","unit_cost":15.66},{"id":28200913,"style_description":"Augusta Sportswear - Attain Color Secure® Performance Long Sleeve T-Shirt","taxable":true,"style_number":"2795","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":1,"total_quantities":1,"goods_stat
us":"","category":" 3-Apparel","unit_cost":19.1},{"id":28200914,"style_description":"Sherriff","taxable":true,"style_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 2-Transfer Services","unit_cost":0.01},{"id":28200915,"style_description":"Franklin Badge","taxable":true,"style_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":0.01},{"id":28200916,"style_description":"","taxable":false,"style_number":"","color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":0.01}],"order_fees_attributes":[],"id":7161334,"customer_due_d
ate":"2021-08-26T00:00:00.000-04:00","custom_created_at":"2021-08-26T00:00:00.000-04:00","invoice_date":"2021-08-26T00:00:00.000-04:00","payment_due_date":"2021-08-26T00:00:00.000-04:00","formatted_invoice_date":"08/26/2021","formatted_customer_due_date":"08/26/2021","formatted_payment_due_date":"08/26/2021","formatted_custom_created_at_date":"08/26/2021","url":"https://www.printavo.com/invoices/7161334","amount_paid":0.0,"amount_outstanding":71.0575,"public_url":"https://www.printavo.com/invoice/a995e8b4d28ae3a530f53b0a62430e69","pdf":"https://www.printavo.com/invoice/a995e8b4d28ae3a530f53b0a62430e69.pdf","workorder":"https://www.printavo.com/invoices/7161334/workorder","packaging_slip":"https://www.printavo.com/invoices/7161334/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4352599,"user_id":39097,"orderstatus_id":196994,"public_hash":"0cc5f3192dc20c2c59b0c46d75d88ea4","production_notes":"

Order Notes: 
Garments coming from Sanmar on
PO P329029476B: 

TLJ763 Cornerstone Duck Cloth Work Jacket: 
Navy: XLT-1, 2XLT-1 

Garment coming from TriMountain on PO P329029476A: 

6000 Lightweight jacket 
Navy: 2XLT-1 

Left chest, all garments: SDG Security logo 
Thread colors: 
Red 1147, White 

Please let me know if you have any questions regarding the logo. 

I'll pick up when completed. 

Thanks! Teresa 
","order_nickname":"P329029476D - sdg security","approved":false,"approved_name":null,"visual_id":20534,"stats":{"paid":false,"paid_date":"2021-04-14"},"notes":"","created_at":"2021-08-26T15:49:00.048-04:00","updated_at":"2021-08-26T15:50:47.668-04:00","due_date":"2021-08-26T15:45:00.000-04:00","order_total":9.0,"order_subtotal":9.0,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"P329029476D","customer":{"full_name":"Teresa Lehner","first_name":"Teresa","last_name":"Lehner","company":"Proforma Graphic Services","email":"teresa.lehner@proforma.com, pgs.inv
oices@proforma.com, veronica.carter@proforma.com","customer_id":0},"order_addresses_attributes":[{"id":20802078,"name":"Customer Billing","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","address1":"Nicholas Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"},{"id":20802079,"name":"Customer Shipping","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"_Proforma Order Confirmation","color":"#B3A8A8"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28199013,"style_description":"sdg security","taxable":true,"style_number":"Logo","color":"","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-
Embroidery on Customer Supplied Item","unit_cost":4.5}],"order_fees_attributes":[],"id":7160861,"customer_due_date":"2021-08-26T00:00:00.000-04:00","custom_created_at":"2021-08-26T00:00:00.000-04:00","invoice_date":"2021-08-26T00:00:00.000-04:00","payment_due_date":"2021-09-10T00:00:00.000-04:00","formatted_invoice_date":"08/26/2021","formatted_customer_due_date":"08/26/2021","formatted_payment_due_date":"09/10/2021","formatted_custom_created_at_date":"08/26/2021","url":"https://www.printavo.com/invoices/7160861","amount_paid":0.0,"amount_outstanding":9.0,"public_url":"https://www.printavo.com/invoice/0cc5f3192dc20c2c59b0c46d75d88ea4","pdf":"https://www.printavo.com/invoice/0cc5f3192dc20c2c59b0c46d75d88ea4.pdf","workorder":"https://www.printavo.com/invoices/7160861/workorder","packaging_slip":"https://www.printavo.com/invoices/7160861/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4352599,"user_id":39097,"orderstatus_id":196994,"public_hash":"e
ff853750c482def55a0c00a9a59f71e","production_notes":"
Order Notes: 
Shirts coming from Sanmar on PO P329028863A: 

L5200 Ladies Interlock Performance polo: 
Brilliant Blue: S-1 
White: S-1 

Left chest, both shirts: Sterigenics logo 
Brilliant Blue shirt: All White thread 
White shirt: Multi-color logo 

Thread sequence for multi-color logo: 
Dark Blue: 1167 
Light Blue: 1095 Green: 
1049 Black 

I'll pick up when completed. 
Thanks! Teresa 
","order_nickname":"P329028863A - Sterigenics","approved":false,"approved_name":null,"visual_id":20533,"stats":{"paid":false,"paid_date":"2021-03-15"},"notes":"","created_at":"2021-08-26T15:46:47.672-04:00","updated_at":"2021-08-26T15:48:33.028-04:00","due_date":"2021-08-26T15:45:00.000-04:00","order_total":9.0,"order_subtotal":9.0,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"P329028863A","customer":{"full_name":"Teresa Lehner","first_name":"Teresa","last_name":"Lehner","com
pany":"Proforma Graphic Services","email":"teresa.lehner@proforma.com, pgs.invoices@proforma.com, veronica.carter@proforma.com","customer_id":0},"order_addresses_attributes":[{"id":20802028,"name":"Customer Billing","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","address1":"Nicholas Dr Nicholas Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"},{"id":20802029,"name":"Customer Shipping","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Proforma Order Confirmation","color":"#B3A8A8"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28198896,"style_description":"Sterigentics","taxable":true,"style_number":"Logo","color":"","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":n
ull,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":4.5}],"order_fees_attributes":[],"id":7160836,"customer_due_date":"2021-08-26T00:00:00.000-04:00","custom_created_at":"2021-08-26T00:00:00.000-04:00","invoice_date":"2021-08-26T00:00:00.000-04:00","payment_due_date":"2021-09-10T00:00:00.000-04:00","formatted_invoice_date":"08/26/2021","formatted_customer_due_date":"08/26/2021","formatted_payment_due_date":"09/10/2021","formatted_custom_created_at_date":"08/26/2021","url":"https://www.printavo.com/invoices/7160836","amount_paid":0.0,"amount_outstanding":9.0,"public_url":"https://www.printavo.com/invoice/eff853750c482def55a0c00a9a59f71e","pdf":"https://www.printavo.com/invoice/eff853750c482def55a0c00a9a59f71e.pdf","workorder":"https://www.printavo.com/invoices/7160836/workorder","packaging_slip":"https://www.printavo.com/invoices/7160836/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"di
scount":0.0,"customer_id":4330402,"user_id":39097,"orderstatus_id":209597,"public_hash":"d193ad7c6ede00c225690c2d87f30011","production_notes":"","order_nickname":"Patrick Lundy - Company Shirt","approved":false,"approved_name":null,"visual_id":20532,"stats":{"paid":false},"notes":"","created_at":"2021-08-26T09:26:34.774-04:00","updated_at":"2021-08-26T09:26:40.580-04:00","due_date":"2021-08-26T10:00:00.000-04:00","order_total":72.5,"order_subtotal":72.5,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Brian Fraley","first_name":"Brian","last_name":"Fraley","company":"Clinton Township Fire Department","email":"bfraley@clintontwp-columbus.org","customer_id":0},"order_addresses_attributes":[{"id":20790457,"name":"Customer Billing","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"3820 Cleveland Avenue","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43224"},{"id":207
90458,"name":"Customer Shipping","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Backordered","color":"#FF0011"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28174705,"style_description":"Company Shirt S/S","taxable":true,"style_number":"5-71391","color":"Navy","size_other":null,"size_xs":null,"size_s":null,"size_m":1,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":60.0},{"id":28174706,"style_description":"Clinton Crest","taxable":true,"style_number":"Logo","color":"LC","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5},{"id":28174707,"style_description
":"LUNDY - White","taxable":true,"style_number":"Name","color":"RC","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":5.0}],"order_fees_attributes":[],"id":7155010,"customer_due_date":"2021-08-26T00:00:00.000-04:00","custom_created_at":"2021-08-26T00:00:00.000-04:00","invoice_date":"2021-08-26T00:00:00.000-04:00","payment_due_date":"2021-08-26T00:00:00.000-04:00","formatted_invoice_date":"08/26/2021","formatted_customer_due_date":"08/26/2021","formatted_payment_due_date":"08/26/2021","formatted_custom_created_at_date":"08/26/2021","url":"https://www.printavo.com/invoices/7155010","amount_paid":0.0,"amount_outstanding":72.5,"public_url":"https://www.printavo.com/invoice/d193ad7c6ede00c225690c2d87f30011","pdf":"https://www.printavo.com/invoice/d193ad7c6ede00c225690c2d87f30011.pdf","workorder":"https://www.printavo.com/invoices/7155010/workorder","packaging_slip":"ht
tps://www.printavo.com/invoices/7155010/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4352599,"user_id":39097,"orderstatus_id":188579,"public_hash":"804ced98afdb8461290558b5cd5ad551","production_notes":"","order_nickname":"Hilliard Bag","approved":false,"approved_name":null,"visual_id":20531,"stats":{"paid":false},"notes":"","created_at":"2021-08-25T14:44:27.528-04:00","updated_at":"2021-08-26T10:19:16.438-04:00","due_date":"2021-08-25T10:00:00.000-04:00","order_total":12.5,"order_subtotal":12.5,"payment_term_id":1818,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Teresa Lehner","first_name":"Teresa","last_name":"Lehner","company":"Proforma Graphic Services","email":"teresa.lehner@proforma.com, pgs.invoices@proforma.com, veronica.carter@proforma.com","customer_id":0},"order_addresses_attributes":[{"id":20780779,"name":"Customer Billing","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","addres
s1":"Nicholas Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"},{"id":20780780,"name":"Customer Shipping","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28153537,"style_description":"GIA\r\nHILLIARD\r\nWILDCATS","taxable":true,"style_number":"Name","color":"White","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":12.5}],"order_fees_attributes":[],"id":7150129,"customer_due_date":"2021-08-25T00:00:00.000-04:00","custom_created_at":"2021-08-25T00:00:00.000-04:00","invoice_date":
"2021-08-25T00:00:00.000-04:00","payment_due_date":"2021-09-24T00:00:00.000-04:00","formatted_invoice_date":"08/25/2021","formatted_customer_due_date":"08/25/2021","formatted_payment_due_date":"09/24/2021","formatted_custom_created_at_date":"08/25/2021","url":"https://www.printavo.com/invoices/7150129","amount_paid":0.0,"amount_outstanding":12.5,"public_url":"https://www.printavo.com/invoice/804ced98afdb8461290558b5cd5ad551","pdf":"https://www.printavo.com/invoice/804ced98afdb8461290558b5cd5ad551.pdf","workorder":"https://www.printavo.com/invoices/7150129/workorder","packaging_slip":"https://www.printavo.com/invoices/7150129/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4330402,"user_id":39097,"orderstatus_id":185903,"public_hash":"409bb5bf7126cdf7d1e83fed9dce29cd","production_notes":"","order_nickname":"Tim Feldman Shirt and Hat","approved":false,"approved_name":null,"visual_id":20530,"stats":{"paid":false},"notes":"","created_at":"2021-08-24
T14:51:23.455-04:00","updated_at":"2021-08-26T09:15:22.853-04:00","due_date":"2021-08-24T10:00:00.000-04:00","order_total":77.8,"order_subtotal":77.8,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Brian Fraley","first_name":"Brian","last_name":"Fraley","company":"Clinton Township Fire Department","email":"bfraley@clintontwp-columbus.org","customer_id":0},"order_addresses_attributes":[{"id":20761464,"name":"Customer Billing","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"3820 Cleveland Avenue","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43224"},{"id":20761465,"name":"Customer Shipping","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Ready for Production
","color":"#85F29B"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28111376,"style_description":"\t\r\n5.11 Performance Polo S/S","taxable":true,"style_number":"","color":"Navy","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":1,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":42.0},{"id":28111377,"style_description":"INSPECTOR\r\nFELDMAN\r\n","taxable":true,"style_number":"rc","color":"White","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":5.0},{"id":28111378,"style_description":"Clinton Crest","taxable":true,"style_number":"LC","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery Addon Metallic","unit_cost":7.5}
,{"id":28111379,"style_description":"Richardson - Richardson - Mesh Back Series 112 Trucker Cap","taxable":true,"style_number":"R112","color":"Navy","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":8.3},{"id":28111380,"style_description":"New Clinton Puffy","taxable":true,"style_number":"FC","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":10.0},{"id":28111381,"style_description":"FELDMAN","taxable":true,"style_number":"BC","color":"Name","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":5.0}],"order_fees_attributes":[],"id":7140357,"customer_due_date":"2021-08-24T0
0:00:00.000-04:00","custom_created_at":"2021-08-24T00:00:00.000-04:00","invoice_date":"2021-08-24T00:00:00.000-04:00","payment_due_date":"2021-08-24T00:00:00.000-04:00","formatted_invoice_date":"08/24/2021","formatted_customer_due_date":"08/24/2021","formatted_payment_due_date":"08/24/2021","formatted_custom_created_at_date":"08/24/2021","url":"https://www.printavo.com/invoices/7140357","amount_paid":0.0,"amount_outstanding":77.8,"public_url":"https://www.printavo.com/invoice/409bb5bf7126cdf7d1e83fed9dce29cd","pdf":"https://www.printavo.com/invoice/409bb5bf7126cdf7d1e83fed9dce29cd.pdf","workorder":"https://www.printavo.com/invoices/7140357/workorder","packaging_slip":"https://www.printavo.com/invoices/7140357/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4344915,"user_id":39097,"orderstatus_id":188580,"public_hash":"583418e1274fedae49b9a6cc9f582b1d","production_notes":"","order_nickname":"Paws with Names","approved":false,"approved_name":null,
"visual_id":20529,"stats":{"paid":true,"paid_date":"2021-01-22"},"notes":"","created_at":"2021-08-23T15:29:38.423-04:00","updated_at":"2021-08-27T10:36:02.850-04:00","due_date":"2021-08-23T15:30:00.000-04:00","order_total":15.0,"order_subtotal":15.0,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Mary Davis","first_name":"Mary","last_name":"Davis","company":"Life Uniform - Reynoldsburg","email":"accountspayable@scrubsandbeyond.com, Store345@scrubsandbeyond.com","customer_id":0},"order_addresses_attributes":[{"id":20742015,"name":"Customer Billing","customer_name":"Mary Davis","company_name":"Life Uniform - Reynoldsburg","address1":"2841 Taylor Square","address2":"Taylor Square RDSW ","city":"Reynoldsburg","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43068"},{"id":20742016,"name":"Customer Shipping","customer_name":"Mary Davis","company_name":"Life Uniform - Reynoldsburg","address1":"","address2":"","city":"","state":"","state_iso":nu
ll,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28069972,"style_description":"Scrubs\r\nUse white thread","taxable":true,"style_number":"","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":0.0},{"id":28069973,"style_description":"White Thread - LC","taxable":true,"style_number":"Logo","color":"Paws","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5}],"order_fees_attributes":[],"id":7130553,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","p
ayment_due_date":"2021-09-07T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"09/07/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7130553","amount_paid":15.0,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/583418e1274fedae49b9a6cc9f582b1d","pdf":"https://www.printavo.com/invoice/583418e1274fedae49b9a6cc9f582b1d.pdf","workorder":"https://www.printavo.com/invoices/7130553/workorder","packaging_slip":"https://www.printavo.com/invoices/7130553/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4890263,"user_id":39097,"orderstatus_id":188580,"public_hash":"ad854d711cdea29136a3a58b315cca78","production_notes":"","order_nickname":"Embroidery","approved":false,"approved_name":null,"visual_id":20528,"stats":{"paid":true,"paid_date":"2021-08-24"},"notes":"","created_at":"2021-08-23T14:52:29.338-04:00","upd
ated_at":"2021-08-24T13:52:38.866-04:00","due_date":"2021-08-23T10:00:00.000-04:00","order_total":172.0,"order_subtotal":160.0,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Karen Meidrum","first_name":"Karen","last_name":"Meidrum","company":"Wizard of Dogz","email":"wizardofdogz@msn.com","customer_id":0},"order_addresses_attributes":[{"id":20740808,"name":"Customer Billing","customer_name":"Karen Meidrum","company_name":"Wizard of Dogz","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20740809,"name":"Customer Shipping","customer_name":"Karen Meidrum","company_name":"Wizard of Dogz","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28066979,"style_description":"","taxable":
true,"style_number":"","color":"","size_other":16,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":16,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":10.0},{"id":28066980,"style_description":"","taxable":false,"style_number":"","color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":null,"unit_cost":6.4}],"order_fees_attributes":[],"id":7129935,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","payment_due_date":"2021-08-23T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"08/23/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7129935","amount_paid":172
.0,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/ad854d711cdea29136a3a58b315cca78","pdf":"https://www.printavo.com/invoice/ad854d711cdea29136a3a58b315cca78.pdf","workorder":"https://www.printavo.com/invoices/7129935/workorder","packaging_slip":"https://www.printavo.com/invoices/7129935/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4890021,"user_id":39097,"orderstatus_id":190428,"public_hash":"0d54e618832cf7cfb1dc0ce81290598d","production_notes":"","order_nickname":"Names on Placemats","approved":false,"approved_name":null,"visual_id":20527,"stats":{"paid":false},"notes":"","created_at":"2021-08-23T14:50:33.249-04:00","updated_at":"2021-08-23T14:50:38.843-04:00","due_date":"2021-08-23T10:00:00.000-04:00","order_total":26.875,"order_subtotal":25.0,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Mattie Phillips","first_name":"Mattie","last_name":"Phillips","company":"","ema
il":"grooms.6@hotmail.com","customer_id":0},"order_addresses_attributes":[{"id":20740742,"name":"Customer Billing","customer_name":"Mattie Phillips","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20740743,"name":"Customer Shipping","customer_name":"Mattie Phillips","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Create Design(s)","color":"#EB5768"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28066858,"style_description":"","taxable":true,"style_number":"","color":"","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":12.5},{"id":28066859,"style_description":"","taxable":false,"style_number":"","
color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":1.0}],"order_fees_attributes":[],"id":7129902,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","payment_due_date":"2021-08-23T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"08/23/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7129902","amount_paid":0.0,"amount_outstanding":26.875,"public_url":"https://www.printavo.com/invoice/0d54e618832cf7cfb1dc0ce81290598d","pdf":"https://www.printavo.com/invoice/0d54e618832cf7cfb1dc0ce81290598d.pdf","workorder":"https://www.printavo.com/invoices/7129902/workorder","packaging_slip":"https://www.printavo.com/i
nvoices/7129902/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4360456,"user_id":39097,"orderstatus_id":188580,"public_hash":"1b75e254d1acc9a4862fe3fb2c172868","production_notes":"
Add actual quantity
","order_nickname":"COUG","approved":false,"approved_name":null,"visual_id":20526,"stats":{"paid":true,"paid_date":"2021-02-12"},"notes":"","created_at":"2021-08-23T10:00:44.806-04:00","updated_at":"2021-08-27T10:35:42.696-04:00","due_date":"2021-08-23T10:00:00.000-04:00","order_total":42.5,"order_subtotal":42.5,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Elaina","first_name":"Elaina","last_name":"","company":"Scrubs and Beyond","email":"accountspayable@scrubsandbeyond.com, manager361@scrubsandbeyond.com","customer_id":0},"order_addresses_attributes":[{"id":20730943,"name":"Customer Billing","customer_name":"Heather","company_name":"Scrubs and Beyond","address1":"12969 Manchester Road","
address2":"","city":"St Louis","state":"Missouri","state_iso":"MO","country":"US","country_iso":"US","zip":"63131"},{"id":20730944,"name":"Customer Shipping","customer_name":"Heather","company_name":"Scrubs and Beyond","address1":"3864 Morse Road","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43219"}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28043503,"style_description":"Central Ohio Urology Group","taxable":true,"style_number":"Logo","color":"","size_other":4,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":4,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":6.5},{"id":28043538,"style_description":"","taxable":true,"style_number":"Name","color":"","size_other":3,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size

xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":3,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":5.5}],"order_fees_attributes":[],"id":7124891,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","payment_due_date":"2021-09-07T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"09/07/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7124891","amount_paid":42.5,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/1b75e254d1acc9a4862fe3fb2c172868","pdf":"https://www.printavo.com/invoice/1b75e254d1acc9a4862fe3fb2c172868.pdf","workorder":"https://www.printavo.com/invoices/7124891/workorder","packaging_slip":"https://www.printavo.com/invoices/7124891/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":fal
se,"discount":0.0,"customer_id":4360456,"user_id":39097,"orderstatus_id":188579,"public_hash":"6b53bf1daf7659da8b0f55f859dcc728","production_notes":"","order_nickname":"Grace Vision","approved":false,"approved_name":null,"visual_id":20525,"stats":{"paid":true,"paid_date":"2021-02-12"},"notes":"","created_at":"2021-08-23T10:00:05.303-04:00","updated_at":"2021-08-27T10:35:19.946-04:00","due_date":"2021-08-23T10:00:00.000-04:00","order_total":24.0,"order_subtotal":24.0,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Elaina","first_name":"Elaina","last_name":"","company":"Scrubs and Beyond","email":"accountspayable@scrubsandbeyond.com, manager361@scrubsandbeyond.com","customer_id":0},"order_addresses_attributes":[{"id":20730926,"name":"Customer Billing","customer_name":"Heather","company_name":"Scrubs and Beyond","address1":"12969 Manchester Road","address2":"","city":"St Louis","state":"Missouri","state_iso":"MO","country":"US","country_iso":"US","zip":"63131"},{"
id":20730927,"name":"Customer Shipping","customer_name":"Heather","company_name":"Scrubs and Beyond","address1":"3864 Morse Road","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43219"}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28043471,"style_description":"Grace Vision","taxable":true,"style_number":"Logo","color":"","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":6.5},{"id":28043472,"style_description":"","taxable":true,"style_number":"Name","color":"","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","u
nit_cost":5.5}],"order_fees_attributes":[],"id":7124882,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","payment_due_date":"2021-09-07T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"09/07/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7124882","amount_paid":24.0,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/6b53bf1daf7659da8b0f55f859dcc728","pdf":"https://www.printavo.com/invoice/6b53bf1daf7659da8b0f55f859dcc728.pdf","workorder":"https://www.printavo.com/invoices/7124882/workorder","packaging_slip":"https://www.printavo.com/invoices/7124882/packing_slip"},{"sales_tax":6.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4289216,"user_id":39097,"orderstatus_id":186871,"public_hash":"737da50785eae6188660bac6623fe55d","produ
ction_notes":"","order_nickname":"test pos","approved":false,"approved_name":null,"visual_id":7,"stats":{"paid":false},"notes":"","created_at":"2021-08-22T15:54:51.061-04:00","updated_at":"2021-08-22T16:02:45.711-04:00","due_date":"2021-08-22T10:00:00.000-04:00","order_total":46.9665,"order_subtotal":44.1,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"Test 7","customer":{"full_name":"Freddy Flintstone","first_name":"Freddy","last_name":"Flintstone","company":"Test Customer","email":"cstocksd@stocksdale.net","customer_id":0},"order_addresses_attributes":[{"id":20727801,"name":"Customer Billing","customer_name":"Freddy Flintstone","company_name":"Test Customer","address1":"77 Bedrock Drive","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":"30245"},{"id":20727802,"name":"Customer Shipping","customer_name":"Freddy Flintstone","company_name":"Test Customer","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso
":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Quote Approved","color":"#F75E70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28036514,"style_description":"Richardson - On-Field Series 585 Wool Blend R-Flex Cap.\r\nS = XS-SM (6-5/8 â?? 7â?�), M = SM-MD (7 â?? 7-1/4â?�), L = LG-XL (7-3/8 â?? 7-5/8â?�)","taxable":true,"style_number":"R585","color":"Black","size_other":null,"size_xs":null,"size_s":1,"size_m":2,"size_l":3,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":6,"goods_status":"ordered","category":" 3-Apparel","unit_cost":7.35}],"order_fees_attributes":[],"id":7123276,"customer_due_date":"2021-08-22T00:00:00.000-04:00","custom_created_at":"2021-08-22T00:00:00.000-04:00","invoice_date":"2021-08-22T00:00:00.000-04:00","payment_due_date":"2021-08-22T00:00:00.000-04:00","formatted_invoice_date":"08/22/2021","formatted_customer_due_date":"08/22/2021","formatted_payment_due_date":"08/22/2021","formatted_custom_created_at_date":"08/22/2021"
,"url":"https://www.printavo.com/invoices/7123276","amount_paid":0.0,"amount_outstanding":46.9665,"public_url":"https://www.printavo.com/invoice/737da50785eae6188660bac6623fe55d","pdf":"https://www.printavo.com/invoice/737da50785eae6188660bac6623fe55d.pdf","workorder":"https://www.printavo.com/invoices/7123276/workorder","packaging_slip":"https://www.printavo.com/invoices/7123276/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4888097,"user_id":39097,"orderstatus_id":185904,"public_hash":"1287e08686aaefb9c9243ec0aa0cfb74","production_notes":"","order_nickname":"New Logo and Embroidery","approved":false,"approved_name":null,"visual_id":20524,"stats":{"paid":false},"notes":"","created_at":"2021-08-20T17:14:22.331-04:00","updated_at":"2021-08-27T15:10:32.528-04:00","due_date":"2021-08-20T10:00:00.000-04:00","order_total":147.8125,"order_subtotal":137.5,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"B
en King","first_name":"Ben","last_name":"King","company":"Reaching The Future Faster","email":"ben.king@fasterfuture.org","customer_id":0},"order_addresses_attributes":[{"id":20722844,"name":"Customer Billing","customer_name":"Ben King","company_name":"Reaching The Future Faster","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20722845,"name":"Customer Shipping","customer_name":"Ben King","company_name":"Reaching The Future Faster","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[{"id":5485789,"transaction_date":"2021-08-25T01:00:00.000-04:00","name":"31077","amount":-20.0,"created_at":"2021-08-25T09:10:28.464-04:00","updated_at":"2021-08-25T09:10:28.464-04:00","user_generated":true}],"orderstatus":{"name":"In Production","color":"#54CC6E"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28025331,"style_description":"Reaching Th
e Future Faster","taxable":true,"style_number":"Logo","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery Setup Fee","unit_cost":70.0},{"id":28025332,"style_description":"Reaching The Future Faster","taxable":true,"style_number":"Logo","color":"Left Chest","size_other":9,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":9,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":7.5}],"order_fees_attributes":[],"id":7120810,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_created_at

date":"08/20/2021","url":"https://www.printavo.com/invoices/7120810","amount_paid":0.0,"amount_outstanding":147.8125,"public_url":"https://www.printavo.com/invoice/1287e08686aaefb9c9243ec0aa0cfb74","pdf":"https://www.printavo.com/invoice/1287e08686aaefb9c9243ec0aa0cfb74.pdf","workorder":"https://www.printavo.com/invoices/7120810/workorder","packaging_slip":"https://www.printavo.com/invoices/7120810/packing_slip"},{"sales_tax":7.5,"total_untaxed":25.08,"discount_as_percentage":false,"discount":0.0,"customer_id":4699113,"user_id":39097,"orderstatus_id":185904,"public_hash":"48acf82f94f2ecd45c3610940aaf6d46","production_notes":"","order_nickname":"Giuseppe's Polo's","approved":false,"approved_name":null,"visual_id":20523,"stats":{"paid":false,"paid_date":"2021-06-04"},"notes":"","created_at":"2021-08-20T17:05:05.995-04:00","updated_at":"2021-08-27T12:04:42.410-04:00","due_date":"2021-08-20T17:00:00.000-04:00","order_total":699.32,"order_subtotal":652.28,"payment_term_id":null,"delivery_method_id":null,"visual_p
o_number":"","customer":{"full_name":"Christopher Leadbeater","first_name":"Christopher","last_name":"Leadbeater","company":"Amerikleen","email":"magnummx111@yahoo.com","customer_id":0},"order_addresses_attributes":[{"id":20722662,"name":"Customer Billing","customer_name":"Christopher Leadbeater","company_name":"Amerikleen","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20722663,"name":"Customer Shipping","customer_name":"Christopher Leadbeater","company_name":"Amerikleen","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"In Production","color":"#54CC6E"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28024929,"style_description":"Sport-Tek - PosiCharge RacerMesh Polo","taxable":true,"style_number":"ST640","color":"Graphite","size_other":null,"size_xs":null,"size_s":null,"size_m":4,"size_l":6,"size_xl":
6,"size_2xl":4,"size_3xl":null,"total_quantities":20,"goods_status":"","category":" 3-Apparel","unit_cost":12.98},{"id":28024931,"style_description":"Giuseppe's ","taxable":true,"style_number":"Logo","color":"LC","size_other":40,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":40,"goods_status":"","category":" 1-Embroidery","unit_cost":6.0},{"id":28024932,"style_description":"","taxable":false,"style_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":25.08},{"id":28024930,"style_description":"Port Authority - Uniforming Twill Cap","taxable":true,"style_number":"C913","color":"Steel Grey","size_other":20,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":20,"goods_status":
"","category":" 3-Apparel","unit_cost":6.38}],"order_fees_attributes":[],"id":7120718,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_created_at_date":"08/20/2021","url":"https://www.printavo.com/invoices/7120718","amount_paid":0.0,"amount_outstanding":699.32,"public_url":"https://www.printavo.com/invoice/48acf82f94f2ecd45c3610940aaf6d46","pdf":"https://www.printavo.com/invoice/48acf82f94f2ecd45c3610940aaf6d46.pdf","workorder":"https://www.printavo.com/invoices/7120718/workorder","packaging_slip":"https://www.printavo.com/invoices/7120718/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.6,"discount_as_percentage":false,"discount":0.0,"customer_id":4472895,"user_id":39097,"orderstatus_id":188580,"public_hash":"0ed193c0
dcbf7a5f1918dad78e616563","production_notes":"



","order_nickname":"Grandview Primary Care shirts","approved":false,"approved_name":null,"visual_id":20522,"stats":{"paid":true,"paid_date":"2021-03-01"},"notes":"","created_at":"2021-08-20T13:40:36.880-04:00","updated_at":"2021-08-25T12:24:40.712-04:00","due_date":"2021-08-20T13:45:00.000-04:00","order_total":16.725,"order_subtotal":15.6,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Brett Stefan","first_name":"Brett","last_name":"Stefan","company":"","email":"drbrett@farabaughchiropractic.com","customer_id":0},"order_addresses_attributes":[{"id":20717088,"name":"Customer Billing","customer_name":"Brett Stefan","company_name":"","address1":"2879 East Dublin Granville Road","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43231"},{"id":20717089,"name":"Customer Shipping","customer_name":"Brett Stefan","company_name":"","address1":"","add
ress2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28012475,"style_description":"Farabaugh \r\nChiropractic\r\nDr. Brett C. Stefan\r\n- White\r\n","taxable":true,"style_number":"Logo","color":"Right Chest","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5},{"id":28012476,"style_description":"Farabaugh \r\nChiropractic","taxable":true,"style_number":"Logo","color":"Front Center","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5},{"id":28012477,"style_description":"","taxable":false,"style_number":"","color":"","
size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":0.6}],"order_fees_attributes":[],"id":7117911,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_created_at_date":"08/20/2021","url":"https://www.printavo.com/invoices/7117911","amount_paid":16.73,"amount_outstanding":-0.004999999999999005,"public_url":"https://www.printavo.com/invoice/0ed193c0dcbf7a5f1918dad78e616563","pdf":"https://www.printavo.com/invoice/0ed193c0dcbf7a5f1918dad78e616563.pdf","workorder":"https://www.printavo.com/invoices/7117911/workorder","packaging_slip":"https://www.printavo.co
m/invoices/7117911/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4330402,"user_id":39097,"orderstatus_id":188579,"public_hash":"a9eaea38090cabc2082ba0f9eb7a9c8f","production_notes":"","order_nickname":"Bryan Childs Hat","approved":false,"approved_name":null,"visual_id":20521,"stats":{"paid":true,"paid_date":"2021-08-26"},"notes":"","created_at":"2021-08-20T11:17:32.473-04:00","updated_at":"2021-08-26T15:45:45.992-04:00","due_date":"2021-08-20T10:00:00.000-04:00","order_total":24.08,"order_subtotal":24.08,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Brian Fraley","first_name":"Brian","last_name":"Fraley","company":"Clinton Township Fire Department","email":"bfraley@clintontwp-columbus.org","customer_id":0},"order_addresses_attributes":[{"id":20713196,"name":"Customer Billing","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"3820 Cleveland Avenue","add
ress2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43224"},{"id":20713197,"name":"Customer Shipping","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28004085,"style_description":"New Era - Stretch Mesh Cap","taxable":true,"style_number":"NE1020","color":"Deep Navy","size_other":null,"size_xs":null,"size_s":1,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":11.58},{"id":28004086,"style_description":"ENG 61 INE","taxable":true,"style_number":"Logo","color":"FC","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"
size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5},{"id":28004087,"style_description":"LT. CHILDS (Red)","taxable":true,"style_number":"Name","color":"BC","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":5.0}],"order_fees_attributes":[],"id":7115941,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_created_at_date":"08/20/2021","url":"https://www.printavo.com/invoices/7115941","amount_paid":24.08,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/a9eaea38090cabc2082ba0f9eb7a9c8f","pdf":"https://www.printavo.c
om/invoice/a9eaea38090cabc2082ba0f9eb7a9c8f.pdf","workorder":"https://www.printavo.com/invoices/7115941/workorder","packaging_slip":"https://www.printavo.com/invoices/7115941/packing_slip"},{"sales_tax":0.0,"total_untaxed":2.77,"discount_as_percentage":false,"discount":0.0,"customer_id":4467961,"user_id":39097,"orderstatus_id":188580,"public_hash":"6197fc797daeae16098120315f90ec49","production_notes":"","order_nickname":"NE Hats","approved":false,"approved_name":null,"visual_id":20520,"stats":{"paid":true,"paid_date":"2021-08-20"},"notes":"","created_at":"2021-08-20T11:13:41.594-04:00","updated_at":"2021-08-20T12:01:28.937-04:00","due_date":"2021-08-20T10:00:00.000-04:00","order_total":72.25,"order_subtotal":72.25,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Bryan Childs","first_name":"Bryan","last_name":"Childs","company":"Clinton Township Fire Department","email":"bchilds61@gmail.com","customer_id":4330402},"order_addresses_attributes":[{"id":20713098,"nam
e":"Customer Billing","customer_name":"Bryan Childs","company_name":"Clinton Township Fire Department","address1":"3820 Cleveland Avenue","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43224"},{"id":20713099,"name":"Customer Shipping","customer_name":"Bryan Childs","company_name":"Clinton Township Fire Department","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28003847,"style_description":"New Era - Stretch Mesh Cap","taxable":true,"style_number":"NE1020","color":"Black/Gold","size_other":null,"size_xs":null,"size_s":4,"size_m":null,"size_l":2,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":6,"goods_status":"","category":" 3-Apparel","unit_cost":11.58},{"id":28003848,"style_description":"","taxable":false,"styl
e_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":2.77}],"order_fees_attributes":[],"id":7115888,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_created_at_date":"08/20/2021","url":"https://www.printavo.com/invoices/7115888","amount_paid":72.25,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/6197fc797daeae16098120315f90ec49","pdf":"https://www.printavo.com/invoice/6197fc797daeae16098120315f90ec49.pdf","workorder":"https://www.printavo.com/invoices/7115888/workorder","packaging_slip":"https://www.pri
ntavo.com/invoices/7115888/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4331808,"user_id":39097,"orderstatus_id":188580,"public_hash":"36215ee644eec7b3857b16504f17f0e5","production_notes":"","order_nickname":"Captains Mugs","approved":false,"approved_name":null,"visual_id":20519,"stats":{"paid":true,"paid_date":"2021-03-18"},"notes":"



","created_at":"2021-08-19T16:36:44.034-04:00","updated_at":"2021-08-24T13:54:12.931-04:00","due_date":"2021-08-19T16:30:00.000-04:00","order_total":30.79875,"order_subtotal":28.65,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"10107","customer":{"full_name":"Luba Istocki","first_name":"Luba","last_name":"Istocki","company":"Auld Crafters","email":"luba@auldcraft.com","customer_id":0},"order_addresses_attributes":[{"id":20705116,"name":"Customer Billing","customer_name":"Luba Istocki","company_name":"Auld Crafters","address1":"","address2":"","city":"","state":"","stat
e_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20705117,"name":"Customer Shipping","customer_name":"Luba Istocki","company_name":"Auld Crafters","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27987215,"style_description":"Captain\r\nName\r\nYear","taxable":true,"style_number":"","color":"","size_other":5,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":5,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":5.5},{"id":27987283,"style_description":"","taxable":true,"style_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":"0-Convenie
nce fee if paying by credit card","unit_cost":1.15}],"order_fees_attributes":[],"id":7111879,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7111879","amount_paid":30.8,"amount_outstanding":-0.001250000000002416,"public_url":"https://www.printavo.com/invoice/36215ee644eec7b3857b16504f17f0e5","pdf":"https://www.printavo.com/invoice/36215ee644eec7b3857b16504f17f0e5.pdf","workorder":"https://www.printavo.com/invoices/7111879/workorder","packaging_slip":"https://www.printavo.com/invoices/7111879/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4431525,"user_id":39097,"orderstatus_id":188579,
"public_hash":"683549bd86c6bfd24c8aa7a7aa7f5027","production_notes":"","order_nickname":"Nate's Shirts/Goalie Shirts/Pink Pennies","approved":false,"approved_name":null,"visual_id":20518,"stats":{"paid":false},"notes":"","created_at":"2021-08-19T15:54:51.985-04:00","updated_at":"2021-08-23T12:04:37.312-04:00","due_date":"2021-08-19T16:00:00.000-04:00","order_total":181.675,"order_subtotal":169.0,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Tim Martini","first_name":"Tim","last_name":"Martini","company":"Alder FC Uniform Account","email":"timmy.martini@gmail.com","customer_id":0},"order_addresses_attributes":[{"id":20703717,"name":"Customer Billing","customer_name":"Tim Martini","company_name":"Alder FC Uniform Account","address1":"","address2":"","city":"","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":""},{"id":20703718,"name":"Customer Shipping","customer_name":"Tim Martini","company_name":"Alder FC Uniform Account","address1":"","
address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27984193,"style_description":"Sport-Tek - Heather Contender Tee","taxable":true,"style_number":"ST360","color":"Vintage Heather","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":2,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27984194,"style_description":"Sport-Tek - Youth Long Sleeve PosiCharge Competitor Tee","taxable":true,"style_number":"YST350LS","color":"Neon Pink","size_other":null,"size_xs":null,"size_s":null,"size_m":1,"size_l":1,"size_xl":1,"size_2xl":null,"size_3xl":null,"total_quantities":3,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27984198,"style_description":"Shields on Pink Pennies","taxable":true,"style_number"
:"","color":"","size_other":10,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":10,"goods_status":"","category":" 2-Transfer Services","unit_cost":5.0},{"id":27984597,"style_description":"Sport-Tek - Long Sleeve PosiCharge Competitor Tee","taxable":true,"style_number":"ST350LS","color":"Neon Pink","size_other":null,"size_xs":null,"size_s":1,"size_m":1,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 3-Apparel","unit_cost":17.0}],"order_fees_attributes":[],"id":7111180,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoic
es/7111180","amount_paid":0.0,"amount_outstanding":181.675,"public_url":"https://www.printavo.com/invoice/683549bd86c6bfd24c8aa7a7aa7f5027","pdf":"https://www.printavo.com/invoice/683549bd86c6bfd24c8aa7a7aa7f5027.pdf","workorder":"https://www.printavo.com/invoices/7111180/workorder","packaging_slip":"https://www.printavo.com/invoices/7111180/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4534205,"user_id":39097,"orderstatus_id":188580,"public_hash":"d1a737dd4c904f11260f47de919af1ad","production_notes":"","order_nickname":"Ben's Bag","approved":false,"approved_name":null,"visual_id":20517,"stats":{"paid":true,"paid_date":"2021-08-19"},"notes":"
Thanks Connie!

I forgot to sent this over to you!

Best of luck this season!!!
","created_at":"2021-08-19T15:38:36.221-04:00","updated_at":"2021-08-22T18:36:05.852-04:00","due_date":"2021-08-19T15:45:00.000-04:00","order_total":40.3125,"order_subtotal":37.5,"payment_term_id":1780,"de
livery_method_id":null,"visual_po_number":"","customer":{"full_name":"Ben Buckley #21 U13","first_name":"Ben","last_name":"Buckley #21 U13","company":"Alder FC Uniform Account","email":"constance.buckley@gmail.com","customer_id":4431525},"order_addresses_attributes":[{"id":20703197,"name":"Customer Billing","customer_name":"Ben Buckley #21 U13","company_name":"Alder FC Uniform Account","address1":"1011 weather vane way","address2":"","city":"plain city","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43064"},{"id":20703198,"name":"Customer Shipping","customer_name":"Ben Buckley #21 U13","company_name":"Alder FC Uniform Account","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27983079,"style_description":"Sport-Tek - Youth PosiCharge Competitor Tee","taxable":tru
e,"style_number":"YST350","color":"White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":16.0},{"id":27983080,"style_description":"Sport-Tek - Youth PosiCharge Competitor Tee","taxable":true,"style_number":"YST350","color":"True Red","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":16.0},{"id":27983081,"style_description":"Sport-Tek - Youth Heather Contender Tee","taxable":true,"style_number":"YST360","color":"Vintage Heather","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27983082,"style_description":"Sport-Tek - Youth Long Sleeve PosiCharge Competitor Tee
","taxable":true,"style_number":"YST350LS","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27983083,"style_description":"WICKING SOCCER SHORTS WITH PIPING","taxable":true,"style_number":"460461","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":13.5},{"id":27983084,"style_description":"High 5 Heavy Duty Backpack","taxable":true,"style_number":"327850","color":"Red / Black","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":37.5},{"id":27983085,"style_description":"Preformance Socks","taxable":true,"style_number":"329110","color":"Blac
k / White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":9.0},{"id":27983086,"style_description":"YOUTH MEDALIST JACKET 2.0","taxable":true,"style_number":"4396","color":"Red / White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":37.0},{"id":27983207,"style_description":"","taxable":false,"style_number":"","color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":1.5}],"order_fees_attributes":[],"id":7110921,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08
-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110921","amount_paid":40.31,"amount_outstanding":0.002499999999997726,"public_url":"https://www.printavo.com/invoice/d1a737dd4c904f11260f47de919af1ad","pdf":"https://www.printavo.com/invoice/d1a737dd4c904f11260f47de919af1ad.pdf","workorder":"https://www.printavo.com/invoices/7110921/workorder","packaging_slip":"https://www.printavo.com/invoices/7110921/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4885896,"user_id":39097,"orderstatus_id":188579,"public_hash":"af313a196ac826d4402108678e00e8e3","production_notes":"","order_nickname":"Ian Extras","approved":false,"approved_name":null,"visual_id":20516,"stats":{"paid":true,"paid_date":"2021-08-21"},"notes":"","crea
ted_at":"2021-08-19T15:34:31.514-04:00","updated_at":"2021-08-23T10:02:05.464-04:00","due_date":"2021-08-19T15:30:00.000-04:00","order_total":42.4625,"order_subtotal":39.5,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Ian Yoder","first_name":"Ian","last_name":"Yoder","company":"Alder FC Uniform Account","email":"deca8500@gmail.com","customer_id":4431525},"order_addresses_attributes":[{"id":20703083,"name":"Customer Billing","customer_name":"Ian Yoder","company_name":"Alder FC Uniform Account","address1":"","address2":"","city":"","state":"","state_iso":"OH","country":"US","country_iso":"US","zip":""},{"id":20703084,"name":"Customer Shipping","customer_name":"Ian Yoder","company_name":"Alder FC Uniform Account","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_a
ttributes":[{"id":27982856,"style_description":"Sport-Tek - Youth PosiCharge Competitor Tee","taxable":true,"style_number":"YST350","color":"White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":16.0},{"id":27982857,"style_description":"Sport-Tek - Youth PosiCharge Competitor Tee","taxable":true,"style_number":"YST350","color":"True Red","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":16.0},{"id":27982858,"style_description":"Sport-Tek - Youth Heather Contender Tee","taxable":true,"style_number":"YST360","color":"Vintage Heather","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit

cost":17.0},{"id":27982859,"style_description":"Sport-Tek - Youth Long Sleeve PosiCharge Competitor Tee","taxable":true,"style_number":"YST350LS","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27982860,"style_description":"WICKING SOCCER SHORTS WITH PIPING","taxable":true,"style_number":"460461","color":"Black","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":13.5},{"id":27982861,"style_description":"High 5 Heavy Duty Backpack","taxable":true,"style_number":"327850","color":"Red / Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":37.5},{"id
":27982862,"style_description":"Preformance Socks","taxable":true,"style_number":"329110","color":"Black / White","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":9.0},{"id":27982863,"style_description":"YOUTH MEDALIST JACKET 2.0","taxable":true,"style_number":"4396","color":"Red / White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":37.0},{"id":27982942,"style_description":"","taxable":false,"style_number":"","color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":1.58}],"order_fees_attributes":[],"id":7110864,"customer_due_date":"2021-
08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110864","amount_paid":42.46,"amount_outstanding":0.002499999999997726,"public_url":"https://www.printavo.com/invoice/af313a196ac826d4402108678e00e8e3","pdf":"https://www.printavo.com/invoice/af313a196ac826d4402108678e00e8e3.pdf","workorder":"https://www.printavo.com/invoices/7110864/workorder","packaging_slip":"https://www.printavo.com/invoices/7110864/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4453693,"user_id":39097,"orderstatus_id":188580,"public_hash":"d5727f9a50eebad110afb4c638e1d332","production_notes":"","order_nickname":"Name on warm up pants","approv
ed":false,"approved_name":null,"visual_id":20515,"stats":{"paid":true,"paid_date":"2021-07-06"},"notes":"","created_at":"2021-08-19T14:45:50.390-04:00","updated_at":"2021-08-27T18:04:22.397-04:00","due_date":"2021-08-19T14:45:00.000-04:00","order_total":4.5,"order_subtotal":4.5,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Norma Egelhoff","first_name":"Norma","last_name":"Egelhoff","company":"Egelhoff Sports Inc","email":"egelhoffsports@sbcglobal.net","customer_id":0},"order_addresses_attributes":[{"id":20701535,"name":"Customer Billing","customer_name":"Norma Egelhoff","company_name":"Egelhoff Sports Inc","address1":"50 Dillmont Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"},{"id":20701536,"name":"Customer Shipping","customer_name":"Norma Egelhoff","company_name":"Egelhoff Sports Inc","address1":"50 Dillmont Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country
":"US","country_iso":"US","zip":"43235"}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27979688,"style_description":"Hershey","taxable":true,"style_number":"Pants","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":4.5}],"order_fees_attributes":[],"id":7110086,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-09-03T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"09/03/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110086","amount_paid":4.5,"amount_outstanding"
:0.0,"public_url":"https://www.printavo.com/invoice/d5727f9a50eebad110afb4c638e1d332","pdf":"https://www.printavo.com/invoice/d5727f9a50eebad110afb4c638e1d332.pdf","workorder":"https://www.printavo.com/invoices/7110086/workorder","packaging_slip":"https://www.printavo.com/invoices/7110086/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4453693,"user_id":39097,"orderstatus_id":188580,"public_hash":"375001d4880973f92cccf905a4ee1dfa","production_notes":"","order_nickname":"K Cheer Headband","approved":false,"approved_name":null,"visual_id":20514,"stats":{"paid":true,"paid_date":"2021-05-27"},"notes":"","created_at":"2021-08-19T14:45:47.289-04:00","updated_at":"2021-08-27T18:04:47.560-04:00","due_date":"2021-08-19T14:45:00.000-04:00","order_total":3.5,"order_subtotal":3.5,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Norma Egelhoff","first_name":"Norma","last_name":"Egelhoff","company":"Egelhoff Spor
ts Inc","email":"egelhoffsports@sbcglobal.net","customer_id":0},"order_addresses_attributes":[{"id":20701531,"name":"Customer Billing","customer_name":"Norma Egelhoff","company_name":"Egelhoff Sports Inc","address1":"50 Dillmont Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"},{"id":20701532,"name":"Customer Shipping","customer_name":"Norma Egelhoff","company_name":"Egelhoff Sports Inc","address1":"50 Dillmont Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27979683,"style_description":"K\r\nCheer\r\n(Royal with white outline - Cheer is also white)","taxable":true,"style_number":"Logo","color":"Left Chest","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null
,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":3.5}],"order_fees_attributes":[],"id":7110084,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-09-03T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"09/03/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110084","amount_paid":3.5,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/375001d4880973f92cccf905a4ee1dfa","pdf":"https://www.printavo.com/invoice/375001d4880973f92cccf905a4ee1dfa.pdf","workorder":"https://www.printavo.com/invoices/7110084/workorder","packaging_slip":"https://www.printavo.com/invoices/7110084/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"custom
er_id":4389442,"user_id":39097,"orderstatus_id":185903,"public_hash":"058fffedc10e97dd8e3f18190021fa3c","production_notes":"","order_nickname":"White's Funeral & Cremation Services","approved":false,"approved_name":null,"visual_id":20513,"stats":{"paid":false},"notes":"","created_at":"2021-08-19T14:45:24.383-04:00","updated_at":"2021-08-19T14:45:31.365-04:00","due_date":"2021-08-19T10:00:00.000-04:00","order_total":241.875,"order_subtotal":225.0,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Roy Buckley","first_name":"Roy","last_name":"Buckley","company":"Buckley Trophies and Embroidery","email":"noemail@nomail.com","customer_id":0},"order_addresses_attributes":[{"id":20701517,"name":"Customer Billing","customer_name":"Roy Buckley","company_name":"Buckley Trophies and Embroidery","address1":"1365 Community Park Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43229"},{"id":20701518,"name":"Customer
Shipping","customer_name":"Roy Buckley","company_name":"Buckley Trophies and Embroidery","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Ready for Production","color":"#85F29B"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27979650,"style_description":"White's Funeral & Cremation Services","taxable":true,"style_number":"Logo","color":"","size_other":30,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":30,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":7.5}],"order_fees_attributes":[],"id":7110077,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date
":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110077","amount_paid":0.0,"amount_outstanding":241.875,"public_url":"https://www.printavo.com/invoice/058fffedc10e97dd8e3f18190021fa3c","pdf":"https://www.printavo.com/invoice/058fffedc10e97dd8e3f18190021fa3c.pdf","workorder":"https://www.printavo.com/invoices/7110077/workorder","packaging_slip":"https://www.printavo.com/invoices/7110077/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4768252,"user_id":39097,"orderstatus_id":185898,"public_hash":"bf8d6e7fffb19f003279c3f53cbe1f35","production_notes":"","order_nickname":"Sweatshirts","approved":false,"approved_name":null,"visual_id":20512,"stats":{"paid":false},"notes":"
Sport-Tek - Super Heavyweight Pullover Hooded Sweatshirt is our most popular heavyweight sweatshirt.  It is 12-ounce, cross-grain 80/20 ring spun combed cotton/poly fleece.


Another option is Gildan - Heavy Blend Crewneck Sweatshirt. it is only 8-ounce,  and 50/50 cotton/poly blend.

Let me know which one you would prefer!

As far as the polos, we can purchase Nike and other similar brands but there is currently a huge inventory shortage on black polos.  Sounds strange, but it's true :( 

","created_at":"2021-08-19T13:21:01.309-04:00","updated_at":"2021-08-19T13:21:07.859-04:00","due_date":"2021-08-19T10:00:00.000-04:00","order_total":1156.184,"order_subtotal":1075.52,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Shae White","first_name":"Shae","last_name":"White","company":"","email":"supremeshaee@gmail.com","customer_id":0},"order_addresses_attributes":[{"id":20698972,"name":"Customer Billing","customer_name":"Shae White","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20698973,"name":"Customer Shipping","cust
omer_name":"Shae White","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Quote Out for Approval","color":"#3B86B8"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27973655,"style_description":"Sport-Tek - Super Heavyweight Pullover Hooded Sweatshirt","taxable":true,"style_number":"F281","color":"Black","size_other":null,"size_xs":2,"size_s":2,"size_m":2,"size_l":4,"size_xl":4,"size_2xl":2,"size_3xl":null,"total_quantities":16,"goods_status":"","category":" 3-Apparel","unit_cost":43.98},{"id":27973656,"style_description":"Gildan - Heavy Blend Crewneck Sweatshirt","taxable":true,"style_number":"18000","color":"Black","size_other":null,"size_xs":2,"size_s":2,"size_m":2,"size_l":4,"size_xl":4,"size_2xl":2,"size_3xl":null,"total_quantities":16,"goods_status":"","category":" 3-Apparel","unit_cost":15.74},{"id":27973657,"style_description":"Bulldog","taxabl
e":true,"style_number":"Logo","color":"","size_other":16,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":16,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5}],"order_fees_attributes":[],"id":7108794,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7108794","amount_paid":0.0,"amount_outstanding":1156.184,"public_url":"https://www.printavo.com/invoice/bf8d6e7fffb19f003279c3f53cbe1f35","pdf":"https://www.printavo.com/invoice/bf8d6e7fffb19f003279c3f53cbe1f35.pdf","workorder":"https://www.printavo.com/invoices/7108794/workorder","packaging_slip":"https://www.printavo.co
m/invoices/7108794/packing_slip"}]}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant