Jodie Willsher, 30, died at the Aldi store in Keighley Road, Skipton on Thursday afternoon after suffering multiple serious injuries.
Neville Hord, 44, from Bradford, was remanded in custody after a three-minute hearing at York Magistrates' Court.
He spoke only to give his name and address and to confirm his date of birth. He is due before Leeds Crown Court on 28 December.
Mrs Willsher's husband Malcolm said she was "lovely and warm" and always had a "smile on her face".
"She was amazing, beautiful and a lovely person. She was a doting mother and a loving wife," he said in a statement.
Colin Breslin, regional managing director at Aldi, described Mrs Willsher as a "much loved and popular colleague", adding that her co-workers were "all deeply shocked and saddened by her death".
"The whole town is in shock and grieving over the loss of Jodie. Christmas this year will an ordeal for many residents," said Skipton mayor Andy Rankine.
The store was closed for the police investigation. Tributes have been left at the edge of the cordon.