10-02-2024 10:48 AM
Hello , this is what my cvs looks like. I have been manipulating it the past couple of days because I keep receiving the same error code 37. can you please help me figure out how to fix this so I can bulk upload my template correctly? Thanks
*Action(SiteID=US|Country=US|Currency=USD|Version=745|CC=UTF-8) | *CategoryID | *Title | *StartPrice | *ConditionID | *Format | Description | PicURL | *ListingDuration | *Quantity | *PostalCode | *DispatchTimeMax | RefundOption | ReturnProfileName | ReturnsAcceptedOption | ReturnShippingCostPaidBy | ReturnsWithinOption | ShippingService | PaymentProfileName | Condition | WeightMinor | Type | C:Brand | *ExternalProductID | *ExternalProductID.Type | ShippingCost | *PaypalAccepted | *PaypalEmailAddress | IMMEDIATEPAYREQUIRED | SKU | C:MPN |
Add | 20614 | PowerfulCordlessAUOSHIHandheldVacuum,10000PaSuction,Rechargeable,LEDLight | 54.99 | 1000 | FixedPrice | Cleananywherewithease!TheAUOSHIHandheldVacuumCleanerfeatures10000Papowerfulsuctioninaportable,wirelessdesign.Idealforhome,office,car,orpethair,it’sequippedwithanLEDlighttohelpyouspotdirtindarkareas.Low-noiseoperationensuresapeacefulcleaningexperience,whilethewashableHEPAfiltermakesmaintenanceabreeze. | https://i5.walmartimages.com/seo/TaoTronics-Air-Fryer-1700W-14-8-Quart-5-in-1-Toaster-Oven-Counterto...https://i5.walmartimages.com/asr/08bc7b71-6057-4f53-9b23-42a314d58924.c86c4ec97f35e8b1a7391d4beab12e...https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084..., https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084..., | GTC | 10 | 02132 | 2 | MoneyBackOrExchange | Standard Shipping | ReturnsAccepted | Buyer | Days_30 | StandardShipping | PayPal | New | 1 | Vacuum | AUOSHI | DoesNotApply | 0 | 1 | Soldbytamy@gmail.com | TRUE | AF1700 | DoesNotApply |
10-03-2024 11:11 AM
@sold.bytamy wrote:
Hello , this is what my cvs looks like. I have been manipulating it the past couple of days because I keep receiving the same error code 37. can you please help me figure out how to fix this so I can bulk upload my template correctly? Thanks
*Action(SiteID=US|Country=US|Currency=USD|Version=745|CC=UTF-8) *CategoryID *Title *StartPrice *ConditionID *Format Description PicURL *ListingDuration *Quantity *PostalCode *DispatchTimeMax RefundOption ReturnProfileName ReturnsAcceptedOption ReturnShippingCostPaidBy ReturnsWithinOption ShippingService PaymentProfileName Condition WeightMinor Type C:Brand *ExternalProductID *ExternalProductID.Type ShippingCost *PaypalAccepted *PaypalEmailAddress IMMEDIATEPAYREQUIRED SKU C:MPN Add 20614 PowerfulCordlessAUOSHIHandheldVacuum,10000PaSuction,Rechargeable,LEDLight 54.99 1000 FixedPrice Cleananywherewithease!TheAUOSHIHandheldVacuumCleanerfeatures10000Papowerfulsuctioninaportable,wirelessdesign.Idealforhome,office,car,orpethair,it’sequippedwithanLEDlighttohelpyouspotdirtindarkareas.Low-noiseoperationensuresapeacefulcleaningexperience,whilethewashableHEPAfiltermakesmaintenanceabreeze. https://i5.walmartimages.com/seo/TaoTronics-Air-Fryer-1700W-14-8-Quart-5-in-1-Toaster-Oven-Counterto...https://i5.walmartimages.com/asr/08bc7b71-6057-4f53-9b23-42a314d58924.c86c4ec97f35e8b1a7391d4beab12e...https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084..., https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084..., GTC 10 02132 2 MoneyBackOrExchange Standard Shipping ReturnsAccepted Buyer Days_30 StandardShipping PayPal New 1 Vacuum AUOSHI DoesNotApply 0 1 Soldbytamy@gmail.com TRUE AF1700 DoesNotApply
Hello @sold.bytamy,
I noticed a few columns with invalid headers:
Type
ExternalProductID
ExternalProductID.Type
I would recommend you remove those columns. Column headers for Item Specifics begin with C: as in C:Color or C:Type. So if you want to include Type as an Item Specific, the column header would be C:Type.
10-12-2024 07:56 PM
Hello, Thank you for your response. I am hoping you can help me. I removed the
Type
ExternalProductID
ExternalProductID.Type
Then, I added C:Type column as stated. Then, it changed the error codes that I am now receiving on my csv. However, the first two still say error code 37. Are you able to assist me with the next following errors? I am unsure what they mean. Can you please help me with all of the errors for a smooth upload? thank you!
2 | Add | Failure | 37 | Error - Input data for tag <Item.PictureDetails.PictureURL[3]> is invalid or missing. Please check API documentation.|Item.PictureDetails.PictureURL[3]| | |||||||||||||||||||||||||||||||
3 | Add | Failure | 37 | Error - Input data for tag <Item.PictureDetails.PictureURL[1]> is invalid or missing. Please check API documentation.|Item.PictureDetails.PictureURL[1]| | |||||||||||||||||||||||||||||||
4 | Add | Failure | 21915469 | Error - Please add at least one valid shipping service option to your listing.| | 21919446|21917236|21920208 | Warning - You are not opted into Business Policies. To continue using this feature please opt in using the following link: https://www.bizpolicy.ebay.com/businesspolicy/policyoptin|https://www.bizpolicy.ebay.com/businesspolicy/policyoptin||Warning - Funds from your sales may be unavailable and show as on hold for a period of time. Learn more:https://www.ebay.com/help/selling/getting-paid/getting-paid-items-youve-sold/pending-payments?id=481...Funds from your sales may be unavailable and show as on hold for a period of time.|Funds from your sales may be unavailable and show as on hold for a period of time. Learn more:https://www.ebay.com/help/selling/getting-paid/getting-paid-items-youve-sold/pending-payments?id=481...PayPalHold|https://www.ebay.com/help/selling/getting-paid/getting-paid-items-youve-sold/pending-payments?id=481...|Warning - This selling account is enabled for payments managed by eBay. PayPal is not currently accepted as a payment method and has been removed from the listing.|PayPal|| | |||||||||||||||||||||||||||||
5 | Add | Failure | 21915469 | Error - Please add at least one valid shipping service option to your listing.| | 21919446|21917236|21920208 | Warning - You are not opted into Business Policies. To continue using this feature please opt in using the following link: https://www.bizpolicy.ebay.com/businesspolicy/policyoptin|https://www.bizpolicy.ebay.com/businesspolicy/policyoptin||Warning - Funds from your sales may be unavailable and show as on hold for a period of time. Learn more:https://www.ebay.com/help/selling/getting-paid/getting-paid-items-youve-sold/pending-payments?id=481...Funds from your sales may be unavailable and show as on hold for a period of time.|Funds from your sales may be unavailable and show as on hold for a period of time. Learn more:https://www.ebay.com/help/selling/getting-paid/getting-paid-items-youve-sold/pending-payments?id=481...PayPalHold|https://www.ebay.com/help/selling/getting-paid/getting-paid-items-youve-sold/pending-payments?id=481...|Warning - This selling account is enabled for payments managed by eBay. PayPal is not currently accepted as a payment method and has been removed from the listing.|PayPal|| |
10-12-2024 07:59 PM
This is the current csv file that I have. thank you for your help in advance!
*Action(SiteID=US|Country=US|Currency=USD|Version=745|CC=UTF-8) | *CategoryID | *Title | *StartPrice | *ConditionID | *Format | Description | PicURL | *ListingDuration | *Quantity | *PostalCode | *DispatchTimeMax | RefundOption | ReturnProfileName | ReturnsAcceptedOption | ReturnShippingCostPaidBy | ReturnsWithinOption | ShippingService | PaymentProfileName | Condition | WeightMinor | C:Type | C:Brand | ShippingCost | *PaypalAccepted | *PaypalEmailAddress | IMMEDIATEPAYREQUIRED | SKU | C:MPN |
Add | 20614 | PowerfulCordlessAUOSHIHandheldVacuum,10000PaSuction,Rechargeable,LEDLight | 54.99 | 1000 | FixedPrice | Cleananywherewithease!TheAUOSHIHandheldVacuumCleanerfeatures10000Papowerfulsuctioninaportable,wirelessdesign.Idealforhome,office,car,orpethair,it’sequippedwithanLEDlighttohelpyouspotdirtindarkareas.Low-noiseoperationensuresapeacefulcleaningexperience,whilethewashableHEPAfiltermakesmaintenanceabreeze. | https://i5.walmartimages.com/seo/TaoTronics-Air-Fryer-1700W-14-8-Quart-5-in-1-Toaster-Oven-Counterto...https://i5.walmartimages.com/asr/08bc7b71-6057-4f53-9b23-42a314d58924.c86c4ec97f35e8b1a7391d4beab12e...https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084..., https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084..., | GTC | 10 | 02132 | 2 | MoneyBackOrExchange | Standard Shipping | ReturnsAccepted | Buyer | Days_30 | StandardShipping | PayPal | New | 1 | Vacuum | AUOSHI | 0 | 1 | Soldbytamy@gmail.com | TRUE | AF1700 | DoesNotApply |
Add | 20614 | AUOSHIWirelessPortableVacuumCleaner,10000Pa,Low-Noise,LED,HEPAFilter | 54.99 | 1000 | FixedPrice | KeepyourspacesspotlesswiththeAUOSHICordlessHandheldVacuumCleaner!Its10000Pasuctionpowertacklesdirt,debris,andpethair,makingitperfectforhome,car,andofficeuse.Rechargeableandlightweight,thisvacuumiseasytocarry,andthewashableHEPAfilterensureslong-lastingperformance. | https://i5.walmartimages.com/seo/TaoTronics-Air-Fryer-1700W-14-8-Quart-5-in-1-Toaster-Oven-Counterto..., https://i5.walmartimages.com/asr/08bc7b71-6057-4f53-9b23-42a314d58924.c86c4ec97f35e8b1a7391d4beab12e..., https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084...https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084... | GTC | 10 | 02132 | 2 | MoneyBackOrExchange | Standard Shipping | ReturnsAccepted | Buyer | Days_30 | StandardShipping | PayPal | New | 1 | Vacuum | AUOSHI | 0 | 1 | Soldbytamy@gmail.com | TRUE | AF1700 | DoesNotApply |
Add | 20614 | LightweightAUOSHIHandheldVacuumCleaner,Cordless,Rechargeable,Home/Car/Office | 54.99 | 1000 | FixedPrice | AUOSHIHandheldVacuumCleaneroffersunmatchedconveniencewithwirelessportabilityand10000Pasuctionpower.Designedforeasycleaningintightspaces,it’sperfectforcars,homes,andoffices.TheLEDlighthelpsilluminatedirt,whilethequiet,low-noisedesignmakesitidealforanytimecleaning. | https://i5.walmartimages.com/seo/TaoTronics-Air-Fryer-1700W-14-8-Quart-5-in-1-Toaster-Oven-Counterto...https://i5.walmartimages.com/asr/08bc7b71-6057-4f53-9b23-42a314d58924.c86c4ec97f35e8b1a7391d4beab12e...https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084...https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084... | GTC | 10 | 02132 | 2 | MoneyBackOrExchange | Standard Shipping | ReturnsAccepted | Buyer | Days_30 | StandardShipping | PayPal | New | 1 | Vacuum | AUOSHI | 0 | 1 | Soldbytamy@gmail.com | TRUE | AF1700 | DoesNotApply |
Add | 20614 | AUOSHI10000PaHandheldVacuumwithLEDLight,Cordless,WashableHEPA,Quiet | 54.99 | 1000 | FixedPrice | SaygoodbyetodirtandpethairwiththeAUOSHIWirelessHandheldVacuum.Itspowerful10000Pasuctionandrechargeablebatterymakeitperfectforquickclean-upsinthehome,office,orcar.TheLEDlightensuresnospotismissed,whilethewashableHEPAfilterkeepsthevacuumintopshape. | https://i5.walmartimages.com/seo/TaoTronics-Air-Fryer-1700W-14-8-Quart-5-in-1-Toaster-Oven-Counterto...https://i5.walmartimages.com/asr/08bc7b71-6057-4f53-9b23-42a314d58924.c86c4ec97f35e8b1a7391d4beab12e...https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084...https://i5.walmartimages.com/asr/3e8f2cbd-3ece-49f7-a2c6-9394ab747712.1f4907fd87f1daabed03f2d0e29084... | GTC | 10 | 02132 | 2 | MoneyBackOrExchange | Standard Shipping | ReturnsAccepted | Buyer | Days_30 | StandardShipping | PayPal | New | 1 | Vacuum | AUOSHI | 0 | 1 | Soldbytamy@gmail.com | TRUE | AF1700 | DoesNotApply |
Welcome to the Seller Tools board! You can chat with other members about seller tools and best practices in using them.
Tools related questions? Learn more about:
Videos: