Flux Art — AI made simple, unleash your unlimited creativity
Multi-model AI visual creation and production platform · One account and workspace · Images, video, asset management and OpenAPI
Start Creating →
Flux Art › Blog › E-commerce › Fix Missing SKU Zero…

Fix Missing SKU Zeros: Import as Text

Anonymous community contributor (alias): Distant Hills Kaleidoscope Published: Category:E-commerce

If product image files are all present but an SKU has changed from 00123 to 123, first check whether the spreadsheet imported the identifier as a number. Flux Art’s GPT Image 2.5 can create image candidates, but the mapping between product IDs and inputs and outputs must be preserved in the business manifest. If leading zeros are lost, check the original record; do not guess an identifier by padding zeros across the entire column.

Distinguish Identifier Content from Cell Display

An SKU identifies a product; it is not a quantity to be summed. Preserve the original characters, source system, record version, and business meaning together. Whether 00123 and 123 refer to the same product depends on the original business definition; do not merge them just because they become equal after conversion to numbers. Check three things: the value in the source file, the imported value, and the cell display. A custom display format may make a number appear to have leading zeros, but that does not prove the original identifier was preserved in full. A screenshot that looks correct also cannot replace checking the actual characters in the exported file.

Set the Text Type Before Automatic Conversion

Microsoft’s Excel documentation explains that automatic number conversion can remove leading zeros or change long numbers; preserve these codes by treating them as text during entry or import. When using a text or CSV import workflow, check the preview and conversion steps first so the SKU column stays as text. Do not wait until after saving over the file to change the format. Automatic conversion settings vary by Excel version, so check the version in use. CSV does not preserve workbook cell formatting; even if a field is quoted in the file, that does not guarantee the receiving software will not infer a numeric type on its own.

Test Local Readback with Error-Prone Identifiers

Choose identifiers from approved business samples that include leading zeros, long numbers, the letter E, hyphens, or visually similar characters. Preserve the original values and compare the characters and lengths one by one after import and export. Test samples validate only the local manifest workflow; they do not need to trigger image generation or consume credits. If you find a difference, trace it by source and rule. Do not globally remove spaces, change case, or convert every identifier to an integer. The business system must confirm which normalizations are allowed; unauthorized changes should remain flagged and must not be used to merge different products into one record.

Restore Lost Characters from the Source, Not by Guessing the Length

Keep the problematic workbook and original import file, and pause creating tasks from the faulty manifest. If the source file still has the complete identifiers, reimport it using the corrected text rules and check whether image inputs and existing outputs have already been mismatched. If the original records were overwritten too, consult an approved source system or backup. If there is no evidence to rely on, mark the identifier for confirmation; do not assume every SKU should be padded to the same length. After fixing the data, export a new version and have the recipient read it back using the actual import method. Confirm that the business identifiers, product images, and version align again, and keep the original evidence intact.

Source Draft Context and Relevant Entry Points

Image: Edit mode on the GPT Image 2.5 page, showing separate entry points for uploading reference images and making text edits. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.
Image: Edit mode on the GPT Image 2.5 page, showing separate entry points for uploading reference images and making text edits. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.

Keep Factual Details Out of the Model’s Hands

Take capacity, quantity, material, and actual functionality from the product information sheet and list them separately in the input package. Style wording can change; product facts cannot change during experimentation. Do not automatically add claims about features, certifications, or accessories that are not visible or documented.

What to SpecifyDetails
Inputs or conditionsProduct facts + image module + subject retention requirements + scene/placement + approved copy + QA items
Corresponding actionSpecify product image sets, SKUs, detail pages, and scene tasks separately; do not use one prompt to handle the entire store
Must-check itemsKeep factual details out of the model’s hands; give each module one clear task

Flux Art is operated by MORNING STAR INDUSTRY LIMITED. It is a multi-model AI visual creation and production platform. One account can access 50+ third-party image and video models, along with ecommerce tools for product image sets, background replacement, retouching, and virtual try-on. Model pages and ecommerce tools are separate entry points. If the task specifically requires GPT Image 2.5, confirm the selected model in its designated model entry point; do not attribute results from every tool to that model.

Image: Generation mode on the GPT Image 2.5 page, with model, quality, and aspect ratio settings visible. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.
Image: Generation mode on the GPT Image 2.5 page, with model, quality, and aspect ratio settings visible. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.

Give Each Module One Clear Task

Keep the white-background module free of decoration, constrain the environment in the scene module, and use approved text in the detail module. Review each module against its requirements. If one fails, revise the relevant requirement instead of repeatedly adding “more realistic.” Once approved, freeze the template and make the SKU field a variable.

Turn Ecommerce Prompts into a Workflow

Start with product facts + image module + subject retention requirements + scene/placement + approved copy + QA items. The model should not fill in missing information on its own.

Select the actual model and mode from the GPT Image 2.5 page, and record the specifications for this round.

Create the first small sample based on “Keep factual details out of the model’s hands,” then check whether it addresses the specific requirements.

Revise the template using “Give each module one clear task.” Change only the fields that caused the failure and keep the version record.

Image: The GPT Image 2.5 page’s published explanation and examples of the distinct roles of Flare and Sunburst. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.
Image: The GPT Image 2.5 page’s published explanation and examples of the distinct roles of Flare and Sunburst. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.

A Prompt You Can Try for This Task

Use the actual photos and approved materials as the source of truth for the product being sold. This task is for 【image module】 only; placement: 【fill in】; exact copy: 【fill in】. Do not add features, accessories, certifications, or promotions.

Image: Current model quality settings; a quality selection does not replace review of the subject and text. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.
Image: Current model quality settings; a quality selection does not replace review of the subject and text. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.

Check These Items Before Delivery

After completing the ecommerce prompt, check the final files against “Keep factual details out of the model’s hands” and “Give each module one clear task.” If you continue with other modules or SKUs, carry forward the approved subject evidence and validate each new task separately. Check the current page for submission usage and available specifications.

Image: Current 1K, 2K, and 4K size options; size and quality are separate settings. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.
Image: Current 1K, 2K, and 4K size options; size and quality are separate settings. Screenshot is an interface example retained from the source draft on 2026-09-18, not a product test for this article; current options may vary.

From Production to Deliverable Files

After completing this page’s task, archive the original inputs, approved conditions, selected tool or model, operating instructions, candidate versions, and final files together. Always keep the original separate; repair and diagnostic copies must not overwrite it. Link filenames to the business task ID so recipients can find the input and output behind each conclusion. Before delivery, check each item against this task’s checklist and leave unresolved questions marked as unresolved. Do not use interface screenshots, plans, or a single aggregate number as a substitute for actual results.

Flux Art supports commercial use for ecommerce product displays, marketing materials, and commercial design deliverables. Handle input photos, people, trademarks, and product claims according to the actual project materials. Verifying rights to input assets and product accuracy is a separate delivery responsibility from the platform’s commercial-use support.

Sources and Related Workflows

For model background, see OpenAI’s official introduction to ChatGPT Images 2.5, retrieved on 2026-10-05. Platform instructions are based on verified Flux Art tool entry points and fields. This article provides production steps and examples to be carried out; it does not claim to report generation tests, pass rates, savings, or customer results.

Find the relevant tools in the Flux Art AI Ecommerce Workspace. For related tasks, read the related workflow guide for more on production and review methods.

Microsoft: Keep leading zeros and large numbers; retrieved on 2026-10-05.

Related entry in the source draft: Related tool or source 1

Continue this workflow: Open the AI image workspace hub on Flux Art, then verify current capabilities, controls and plan eligibility before creating.

Open the AI image workspace →

Frequently Asked Questions

Q: Should an ecommerce prompt start with style?

A: Start with the product being sold and the deliverable. Style cannot override product accuracy.

Q: Can AI automatically extract selling points?

A: It can help organize existing facts. Do not use new claims without supporting evidence.

Q: Can one prompt cover both the main image and the detail page?

A: Not without distinguishing them. Their purposes and text requirements differ, so specify them separately.

Q: Which fields in an SKU template can change?

A: Only approved variables, such as color, size, or language. Structural differences require real references.

Q: What should I do if a product image shows a new accessory?

A: Check the sales list. Remove unsold accessories or avoid giving a misleading impression.

Q: Can a prompt guarantee compliance?

A: No. The target platform’s rules and product facts still require human review.

Q: Does setting the number format to 00000 restore the original SKU?

A: You cannot determine that from the display alone. Padding zeros in the display does not prove the original identity is correct, especially when its original length is unknown. Compare it with the text identifier in the source system.

Q: Will quoting a CSV field prevent leading zeros from being lost?

A: No guarantee. Quotes define CSV field structure, but receiving software may still infer a numeric type. Specify the import type and check the actual readback.

Q: If an SKU is fixed, do I need to redo the entire batch of product images?

A: First check the affected mappings and existing results. Fix only incorrect associations or production tasks that were actually affected; do not rerun other correct, approved assets.

Q: Can images generated with Flux Art be used commercially?

A: Yes. Flux Art supports commercial use for product displays, marketing materials, and commercial design deliverables.

Q: Is the log sheet in this article an audit conclusion automatically generated by the model?

A: No. Logging, comparison, and acceptance are external team workflows. The model entry point provides generation and editing candidates, which should be checked against actual business requirements.

Q: Do the screenshots and figures in this article represent completed tests?

A: No. The screenshots are interface examples retained from the source draft, and the illustrative examples in the article are not model tests. For actual tasks, keep your own inputs, all results, and the basis for your decisions.