Import .txt file data to creating Invoice

PortraitEFX · ‎August 16, 2022

How can I get the following .txt data somewhat automatically into a quickbooks invoice?

Here is the .txt file information directly given by our photo production software:

OrderFirstName=Testfirstname
OrderLastName=Consumerlastname
OrderAddress1=9999 Testingonly Street
OrderAddress2=
OrderCity=Testcity
OrderState=US-TX
OrderZip=77096
OrderEmail=[email address removed]
OrderReferenceID=PNW2177
ExtLabCustomerID=ChrisOGPTestAcct
ExtOrderKey=21288146034
ExtInstitution=Demo Demo
ExtSubjectName=Sample Child0
ExtSubjectGroup=Group 1
ExtSubjectIdentifier=
ExtTeacher=
Index=1
Qty=3
Size=7x10
Tmp.text=RESET
Tmp.sku=
Tmp.prodfirstname=Sample
Tmp.prodlastname=Child0
Tmp.prodidentifier=
Tmp.prodgroup=
Tmp.prodteacher=
Media=Luster
Template=X:\Templates\Borders\gotphoto templates\4up 3x5.crd
Tmp.size=7x10
Tmp.media=Luster
Tmp.template=X:\Templates\Borders\gotphoto templates\4up 3x5.crd
Filepath=fotograf-[removed].jpg
Qty=1
Size=8x10
Tmp.text=RESET
Tmp.sku=
Tmp.prodfirstname=Sample
Tmp.prodlastname=Child0
Tmp.prodidentifier=
Tmp.prodgroup=
Tmp.prodteacher=
Media=Luster
Template=X:\Templates\Borders\gotphoto templates\1up 8x10.crd
Tmp.size=8x10
Tmp.media=Luster
Tmp.template=X:\Templates\Borders\gotphoto templates\1up 8x10.crd
Filepath=fotograf-[removed].jpg
Qty=1
Size=5x8
Tmp.text=RESET
Tmp.sku=2-3x5 MAGNET w/Name
Tmp.prodfirstname=Sample
Tmp.prodlastname=Child0
Tmp.prodidentifier=
Tmp.prodgroup=
Tmp.prodteacher=
Media=Luster
Template=X:\Templates\Borders\gotphoto templates\2 up magnet 3x5 year and name.crd
Tmp.size=5x8
Tmp.media=Luster
Tmp.template=X:\Templates\Borders\gotphoto templates\2 up magnet 3x5 year and name.crd
Tmp.first name=Sammy
Tmp.GPyear=2024
Filepath=fotograf-[removed].jpg

Mark_R · ‎August 16, 2022

It's good to see you here in the Community, @PortraitEFX.

I'd love to help you with your concern about importing a .txt file in QuickBooks Desktop. But can you please share more information about it? Are you referring to an invoice form? Any additional details would help us provide the best resolution on this matter.

Please know you can continue to reach me here with your additional questions. I'll be standing by for your response.

Fiat Lux - ASIA · ‎August 16, 2022

@PortraitEFX

Are you using a certain app?

PortraitEFX · ‎August 18, 2022

The txt file information has all the product and qty information we need to bill our pro photographers we print for. We need a way to import that information from our print production software into QuickBooks Desktop to create an invoice so we can then bill them for the prints ordered.

Fiat Lux - ASIA · ‎August 18, 2022

Explore this 3rd party tool to import your invoice data in txt files

https://transactionpro.grsm.io/qbd

Topics

Training

Community

Resources

Import .txt file data to creating Invoice